sql 怎么进行查询之后得到的结果集进行分组，后对得到的分组进行排序，并输出该分组的最大值？

Question

sql 怎么进行查询之后得到的结果集进行分组，后对得到的分组进行排序，并输出该分组的最大值？

Answer 1

select top 1 字段，count(*) from 表 group by 字段 order by count(*) desc

Answer 2

你这个相当于select *，[表] from [表] 当然不行了，另外我不是太明白你的意思   是分组 然后组内排名吗? SELECT RANK() OVER (PARTITION BY OrderID ORDER BY PurchaseCount) AS POS,OrderID,PurchaseCount,* FROM  dbo.TB_PurchaseOrderDetail   还是这么样子的 描述的清楚点

Answer 3

我就想先分组后在组内排序取每组第一个。

Answer 4

SELECT UserName,MAX(aa) AS age FROM (SELECT * FROM Users WHERE Userid>1) AS t GROUP BY t.UserName

Answer 5

大哥,你这题目太抽象了,完全不知道你在说什么!WITH a AS ( SELECT Account , UserName , ROW_NUMBER() OVER ( ORDER BY Account ) AS rowid FROM dbo.frmuser X GROUP BY Account , UserName ) SELECT MAX(rowid) FROM a ORDER BY rowid