题解 | 找出所有员工当前薪水salary情况
找出所有员工当前薪水salary情况
https://www.nowcoder.com/practice/ae51e6d057c94f6d891735a48d1c2397
SELECT DISTINCT (salary) as salary FROM salaries ORDER BY salary DESC ;
用distinct对salary字段进行去重,desc倒序排序
找出所有员工当前薪水salary情况
https://www.nowcoder.com/practice/ae51e6d057c94f6d891735a48d1c2397
SELECT DISTINCT (salary) as salary FROM salaries ORDER BY salary DESC ;
用distinct对salary字段进行去重,desc倒序排序
相关推荐