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