题解 | #出现三次以上相同积分的情况#

关于窗口函数row_number()over()的妙用

select distinct number from (select *,row_number()over(partition by number order by number) as N from grade) as A where N>=3 ORDER BY number