select ROW_NUMBER() over (partition by [f1] order by [f2] ),* from [t1]
SQL中的行号ROW_NUMBER()
转载于:https://www.cnblogs.com/sohobloo/archive/2011/11/10/2244577.html
select ROW_NUMBER() over (partition by [f1] order by [f2] ),* from [t1]
转载于:https://www.cnblogs.com/sohobloo/archive/2011/11/10/2244577.html