SQL 分组后按照排序取第一个 - 为什么？？
因为用到了将Sql某个表中分组后再按照某种分类取第一个，找了一下，还真有相关的~注row_number（）函数在上sql2005有效
代码
SELECT ID,
media_name,
media_type,
rownum,create_date
FROM (select media_id,resource_name ,media_type,create_date, row_number() over(partition by media_type order by create_date desc)
as rowNum from comm_media_info) k where k.rowNum=1
media_name,
media_type,
rownum,create_date
FROM (select media_id,resource_name ,media_type,create_date, row_number() over(partition by media_type order by create_date desc)
as rowNum from comm_media_info) k where k.rowNum=1
版权声明：本文为Jacky-qiao原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。