有一种方法可以做到这一点，在SQLServer中，在其他数据库中，您可以检查顶级的等价项。

with source_qry
   as(
    SELECT F.origin, F.destination, COUNT(DISTINCT E.ename), COUNT(F.flno) as cnt_flno
      FROM Flights F, 
           Employees E, 
           Certified C, 
           Aircraft A
     WHERE E.eid = C.eid 
       AND E.salary > 100000 
       AND A.aid = C.aid 
       AND F.distance >= A.cruisingrange
    GROUP BY E.ename, F.origin, F.destination
         )
select top 1* 
  from source_qry
order by cnt_flno desc

SELECT F.origin, F.destination, COUNT(DISTINCT E.ename), COUNT(F.flno)
FROM Flights F, Employees E, Certified C, Aircraft A
WHERE E.eid = C.eid AND E.salary > 100000 AND A.aid = C.aid AND F.distance >= A.cruisingrange
GROUP BY E.ename, F.origin, F.destination
ORDER BY 4 DESC
LIMIT 1;

WITH data AS (
    SELECT F.origin, F.destination, COUNT(DISTINCT E.ename) AS cnt_ename, COUNT(F.flno) AS cnt,
        MAX(COUNT(F. flno)) OVER () AS maxcnt
    FROM Flights F, Employees E, Certified C, Aircraft A
    WHERE E.eid = C.eid AND E.salary > 100000 AND A.aid = C.aid AND F.distance >= A.cruisingrange
    GROUP BY E.ename, F.origin, F.destination
)
SELECT * FROM data WHERE cnt = maxcnt;

这将处理最大数量的领带。摆脱使用的习惯 top 以及 limit 不加区别地。