由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
JobHunting版 - leetcode Nth Highest Salary 谁做出来了?
相关主题
初级SQL问题一道sql
SQL面题,大家练练吧发个FB电面SQL题目攒个人品希望H1B抽中
这题怎么做请教个面试时遇到的sql 题
SQL run a stored procedure by fetching from a cursor row by (转载)请教SQL面试题
问个sql小提。大牛勿进请教个SQL的问题
请教: SQL 店面题一道小题
How to design the sql for this problem? (转载)面试SQL query 求解!
报offer,加问问题SQL 面试题 - 请高手指点
相关话题的讨论汇总
话题: salary话题: select话题: employee话题: distinct话题: order
进入JobHunting版参与讨论
1 (共1页)
H******7
发帖数: 1728
1
我的答案一直得到wrong answer
SELECT Salary FROM Employee ORDER BY Salary DESC LIMIT N, 1
谁给指点一下!?谢谢
a*****a
发帖数: 46
2
select if(s=2147483648, null, s) from (
(select 2147483648 as s)
union all
(select distinct Salary as s from Employee)
) x
order by s Desc limit N, 1
这个可以过,但估计不是很好
z*u
发帖数: 329
3
Try this
SELECT DISTINCT(Emp1.Salary) FROM Employee Emp1 WHERE (N-1) = (SELECT COUNT(
DISTINCT(Emp2.Salary))
FROM Employee Emp2 WHERE Emp2.Salary > Emp1.Salary)
T******7
发帖数: 1419
4
能简单解释一下么

COUNT(

【在 z*u 的大作中提到】
: Try this
: SELECT DISTINCT(Emp1.Salary) FROM Employee Emp1 WHERE (N-1) = (SELECT COUNT(
: DISTINCT(Emp2.Salary))
: FROM Employee Emp2 WHERE Emp2.Salary > Emp1.Salary)

s***y
发帖数: 904
5
这是mysql的解法吧
别的环境不管用的

【在 H******7 的大作中提到】
: 我的答案一直得到wrong answer
: SELECT Salary FROM Employee ORDER BY Salary DESC LIMIT N, 1
: 谁给指点一下!?谢谢

s***y
发帖数: 904
6
select name, salary from
(select name, salary, (rank ()over (order by salary desc)) as rank) tabel1
where table1.rank=n
z*u
发帖数: 329
7
The idea is just simple, in order to find the Nth highest salary , we just
find the salary that has exactly N - 1 salaries greater than itself.

【在 T******7 的大作中提到】
: 能简单解释一下么
:
: COUNT(

r****n
发帖数: 63
8
DECLARE M;
SET M=N-1;
SELECT DISTINCT Salary FROM Employee ORDER BY Salary DESC LIMIT M, 1;
a*****2
发帖数: 96
9
CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
RETURN (
# Write your MySQL query statement below.
SELECT IF((SELECT COUNT(DISTINCT(Salary)) FROM Employee) < N, null,
orderedtable.Salary) AS 'NthHighestSalary'
FROM
(SELECT DISTINCT (Salary) AS Salary FROM Employee ORDER BY Salary
DESC LIMIT N) AS orderedtable
ORDER BY orderedtable.Salary ASC LIMIT 1
);
END
n*******s
发帖数: 17267
10
here
http://www.programmerinterview.com/index.php/database-sql/find-

【在 T******7 的大作中提到】
: 能简单解释一下么
:
: COUNT(

1 (共1页)
进入JobHunting版参与讨论
相关主题
SQL 面试题 - 请高手指点问个sql小提。大牛勿进
再请教SQL问题请教: SQL 店面题
问一个数据库的题 (转载)How to design the sql for this problem? (转载)
SQL find distinct values in large table (转载)报offer,加问问题
初级SQL问题一道sql
SQL面题,大家练练吧发个FB电面SQL题目攒个人品希望H1B抽中
这题怎么做请教个面试时遇到的sql 题
SQL run a stored procedure by fetching from a cursor row by (转载)请教SQL面试题
相关话题的讨论汇总
话题: salary话题: select话题: employee话题: distinct话题: order