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语句的结果