find the third highest salary?
Answers were Sorted based on User's Feedback
Answer / selvaraj v, anna university co
Find the HIGHEST SALARY in Employee Table :
-------------------------------------------
select * from emp where sal=(select max(sal) from emp)
order by empno;
Find the 3'rd HIGHEST SALARY in Emp Table :
-----------------------------------------------
SELECT * FROM EMP e WHERE 3=(SELECT COUNT(*) FROM EMP x
WHERE x.SAL>=E.SAL);
It's e,x are ALIAS NAME of EMP Table.
Is This Answer Correct ? | 14 Yes | 2 No |
Answer / noorulahaq
select min(sal) from emp where sal in (
select sal from
( select sal from emp order by sal desc )
where rownum <=3 )
Is This Answer Correct ? | 26 Yes | 17 No |
Answer / rohit kumar
select min(sal) from (select sal from emp order by sal
desc) where rownum <= 3
Is This Answer Correct ? | 17 Yes | 8 No |
Answer / uday kiran
Its is like Nth highest salary.....
Select * from Employee where salary =
(Select max(Salary) from Employee where salary < (Select max
(Salary) from Employee where
Salary<(Select max(Salary) from Employee where
Salary <…………………………………………… N
Is This Answer Correct ? | 15 Yes | 10 No |
Answer / nripesh agarwal
select * from emp where salary=(select distinct salary from
emp order by salary desc limit n,1)
// for Nth highest value put n=N-1....
//for 3rd highest put n=2........
Is This Answer Correct ? | 7 Yes | 2 No |
Answer / srinath reddy
select * from emp e1 where 3 = (select count(*) from emp e2
where e1.salary <= e2.salary);
instead of answer we can say this as a solution where we can
find nth also
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / imran ansari
find n th highest salary replace n with 1,2,3....to find second,third,fourth........sal
SELECT sal from emp order by sal desc limit 2,1
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / nripesh agarwal
select * from emp where salary=(select salary from emp
order by salary desc N,1);
// Put the value for N as for Nth highest salary
// e.g. for 2nd put N=2 , for 3rd put N=3 and so on...
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / chandra sekhar
SELECT * FROM EMP e
where 3=(select count(*) from emp
where e.sal<=sal)
Using this correlated subquery we can easily get any one
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / kiran
select salary from employees e where 3 = (select count
(distinct salary) from employees f where
e.salary <= f.salary);
Is This Answer Correct ? | 1 Yes | 0 No |
how a reference cursor works?what all adnvantages are gained with it..specify the situation?
What are the benefits of pl sql?
How do you copy a table in sql?
What is the command used to fetch the first 5 characters of a string?
How do I order columns in sql?
write a qurey for finding the length of the sting.
How many scalar data types are supported in pl/sql?
What is the difference between rename and alias?
How do you remove duplicate records from a table?
explain normalization concept? : Sql dba
what are the type of locks ? : Sql dba
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?