你可以 order by 以及 limit :

SELECT movieName, Count(*) NoOfReviews 
FROM MovieReviews 
GROUP BY movieName
ORDER BY NoOfReviews DESC
FETCH FIRST ROW WITH TIES

这给你的电影与大多数评论，包括领带。
请注意，行限制子句只能从oracle12开始使用。在早期版本中，一种选择是 RANK() :

SELECT movieName, NoOfReviews
FROM (
    SELECT movieName, Count(*) NoOfReviews, RANK() OVER(ORDER BY Count(*)) rn 
    FROM MovieReviews 
    GROUP BY movieName
) t
WHERE rn = 1

您可以使用 having 条款。也就是说，这是相当麻烦的事情 having 窗口函数是更好的解决方案：

SELECT *
FROM (SELECT movieName, Count(*) as NoOfReviews,
             MAX(count(*)) OVER ()  as max_NoOfReviews
      FROM MovieReviews 
      GROUP BY movieName
     ) mr
WHERE NoOfReviews = max_NoOfReviews