11.9 给结果分等级

select (select count(distinct b.sal) 
from emp b
where b.sal<=a.sal) as rnk,
a.sal
from emp a;

posted @ 2017-09-14 22:07  屠魔的少年  阅读(144)  评论(0)    收藏  举报