设为首页 加入收藏

TOP

leetcode数据库sql之DepartmentTopThreeSalaries
2015-11-21 02:03:31 来源: 作者: 【 】 浏览:0
Tags:leetcode 数据库 sql DepartmentTopThreeSalaries

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


】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇SQL-Oracle中的函数 下一篇SQL查询语句总结

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: