find the third highest salary?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / venkatk

23 Answers
43441 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

find the third highest salary?..

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

find the third highest salary?..

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

find the third highest salary?..

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

find the third highest salary?..

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

find the third highest salary?..

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

find the third highest salary?..

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

find the third highest salary?..

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

find the third highest salary?..

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

find the third highest salary?..

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

find the third highest salary?..

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

Post New Answer