rank () OVER(),dense_rank() OVER(),row_number() OVER() 對結果集操作不同之處

select * from tb_wl

SELECT *,rank () OVER (ORDER BY num) rank FROM tb_wl

SELECT *,dense_rank() OVER (ORDER BY num) rank FROM tb_wl

SELECT *,row_number() OVER (ORDER BY num) rank FROM tb_wl

執行上面sql語句的結果