SELECT TOP 1 University FROM student GROUP BY University ORDER BY SUM(1) DESC
'top' 好像不是SQL规范里面的吧。 有没有办法不用TOP做这题?
怎么不是?用top做比较方便。
不用TOP的话SELECT University FROM student GROUP BY University Having SUM(1) = ( SELECT MAX(cnt) FROM (SELECT SUM(1) AS cnt FROM student GROUP BY University) x )
FROM student
GROUP BY University
ORDER BY SUM(1) DESC
FROM student
GROUP BY University
Having SUM(1) = (
SELECT MAX(cnt)
FROM (SELECT SUM(1) AS cnt FROM student GROUP BY University) x
)