数据库SQL实战 No.8
找出所有员工当前薪水salary情况
http://www.nowcoder.com/questionTerminal/ae51e6d057c94f6d891735a48d1c2397
SELECT DISTINCT salary from_date FROM salaries
WHERE salaries.to_date = '9999-01-01'
ORDER BY salaries.salary DESC
SELECT DISTINCT salary from_date FROM salaries
WHERE salaries.to_date = '9999-01-01'
GROUP BY salaries.salary
ORDER BY salaries.salary DESC
数据库SQL实战答案 文章被收录于专栏
该专栏为“数据库SQL实战”的配套题解
查看14道真题和解析