leetcode数据库sql之Department Top Three Salaries

mac2022-06-30  96

leetcode原文引用:

How would you print just the 10th line of a file?

For example, assume that file.txt has the following content:

Line 1 Line 2 Line 3 Line 4 Line 5 Line 6 Line 7 Line 8 Line 9 Line 10 Your script should output the tenth line, which is: Line 10 我的sql语句如下:

SELECT d.name as department, e.name,e.salary FROM Employee e JOIN Department d ON e.departmentid = d.id and (SELECT COUNT(DISTINCT (salary)) FROM Employee WHERE departmentid = e.departmentid AND salary > e.salary ) < 3 ORDER BY d.id ASC , e.salary DESC

转载于:https://www.cnblogs.com/iamconan/p/7383576.html

相关资源:数据库系统概念-原书第六版,书本示例表、数据sql文件(如instructor,department建表sql和数据)
最新回复(0)