不解释,全靠悟性:
select
loan_num,
row_number() over(order by loan_num asc) as 'Row Number',
rank() over(order by loan_num asc) as 'Rank',
dense_rank() over(order by loan_num asc) as 'Dense Rank'
from dbo.tals_loan
不解释,全靠悟性:
select
loan_num,
row_number() over(order by loan_num asc) as 'Row Number',
rank() over(order by loan_num asc) as 'Rank',
dense_rank() over(order by loan_num asc) as 'Dense Rank'
from dbo.tals_loan
转载于:https://www.cnblogs.com/bluelight4587/p/5292894.html