Rank() over (partition by……order by……）与dense_rank() over (partition by……order by……）的区别

筛选出每个月，门诊就诊人次前5的疾病。

Rank() over (partition by……order by……）的用法与效果：

SELECT * 
from
(SELECT a.`医疗机构名称`,a.时间,a.疾病组名称,a.门诊就诊人次,Rank() over (partition by a.`医疗机构名称`,a.时间 order by  a.门诊就诊人次 desc) as totalfee_num
 from 0804renmin a) b
where totalfee_num <=5;

dense_rank() over (partition by……order by……）的用法与效果：

SELECT * 
from
(SELECT a.`医疗机构名称`,a.时间,a.疾病组名称,a.门诊就诊人次,dense_rank() over (partition by a.`医疗机构名称`,a.时间 order by  a.门诊就诊人次 desc) as totalfee_num
 from 0804renmin a) b
where totalfee_num <=5;