select *,row_number() over(partition by item order by date ) as t from table1
item 要group by的字段
select *,row_number() over(partition by item order by date ) as t from table1
item 要group by的字段
转载于:https://www.cnblogs.com/zhang9418hn/archive/2012/09/04/2670477.html