随笔分类 -  mysql_niuke_questions

mysql在牛客网上的刷题记录
sql实战_统计当前工资的排名情况
摘要：问题：已知存在一张工资表，请查询出每个员工的工号、工资、排名 解答：select s1.emp_no,s1.salary,(count(distinct s2.salary)) as rank from salaries as s1,salaries as s2 where s1.to_date=" 阅读全文
posted @ 2019-07-16 10:15 helloworldmybokeyuan 阅读(473) 评论(0) 推荐(0)