效果和group by一样,比group by要方便,
相当对group by中同类型的值中添加一个行号;
partition by [q] :q表示要进行分组查询的字段
order by [datatime]:datatime表示进行排序的字段
ccc表示别名;
s.ccc = 1表示取分组的第一个
s是表的别名:
select s.* from (
select *, row_number() over (partition by [q] order by [datatime]) as ccc
from [db].[dbo].[tb])s
WHERE s.ccc = 1