不解释,全靠悟性:
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