--三种函数进行对比
--rank:
select id
,name
,score
,rank() over(order by score) as rank
from dw_zdb.tmp_temp_inland_train
--row_number
select id
,name
,score
,row_number() over(order by score) as dense_number
from dw_zdb.tmp_temp_inland_train
--dense_number
select id
,name
,score
,dense_number() over(order by score) as dense_number
from dw_zdb.tmp_temp_inland_train