select Name,TotalTrans as asd from (select Name, COUNT(name) as
TotalTrans from trans group by Name) as sub1 group by Name, TotalTrans
having TotalTrans = MAX(TotalTrans)
我想獲取表上發生的總交易（計數）的名稱和最大值
我會TOP在這裡使用查詢：
SELECT TOP 1 name, COUNT(name) AS TotalTrans
FROM trans
GROUP BY name
ORDER BY COUNT(name) DESC;
如果可能有多個名稱與最高計數相關聯，則使用TOP 1 WITH TIES或添加另一個排序級別來ORDER BY打破平局。
本文收集自互联网，转载请注明来源。
如有侵权，请联系 [email protected] 删除。
我来说两句