sql:row_number()先分组后自动排序

-- 先按code分组，再按Name排序

SELECT Code,Name, row_number() OVER( PARTITION BY Code ORDER BY Name DESC ) RN FROM Base_Commodity 

ROW_NUMBER ( ) OVER ( PARTITION BY CurrName, YEAR ( RateDate ), MONTH ( RateDate ) ORDER BY RateDate ) AS RowNum 

PS:如想再查询序号1的记录

SELECT  * FROM (
SELECT Code,Name, row_number() OVER( PARTITION BY Code ORDER BY Name DESC ) RN FROM Base_Commodity 
) P
where 
RN ='1' ;