Find out the 3rd highest salary?

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

Question Posted / guest

51 Answers
66385 Views
BirlaSoft, DAC, Silvia Infotech, Sutra Infotech, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Find out the 3rd highest salary?..

Answer / durgashivashankar

select min(sal) from (Select rownum,sal FROM emp> Order
by sal desc)
where rownum<=3

Is This Answer Correct ?

0 Yes

0 No

Find out the 3rd highest salary?..

Answer / nikhilesh roy

WITH
CTE as
(select emp_id,salary,rn=row_number() over (order by salary desc) from emp_table )
select * from CTE where rn=3;

Is This Answer Correct ?

0 Yes

0 No

Find out the 3rd highest salary?..

Answer / virendra

select ename, salary from emp where salary=(select top 1
salary from (select distinct top 3 salary from emp order
by salary desc) a order by salary)

Is This Answer Correct ?

7 Yes

8 No

Find out the 3rd highest salary?..

Answer / ajay kumar

SELECT DISTINCT SAL FROM EMP WHERE SAL = (SELECT DISTINCT
SAL FROM EMP X WHERE &N= (SELECT COUNT(DISTINCT SAL) FROM
EMP Y WHERE Y.SAL>X.SAL))
/
AFTER RUNNING THE QUERY PUT THE VALUE OF N

Is This Answer Correct ?

0 Yes

1 No

Find out the 3rd highest salary?..

Answer / sachin saini

select min(salary) from table_name where salary in(select
top 3 salary from table_name order by salary desc )

Is This Answer Correct ?

0 Yes

1 No

Find out the 3rd highest salary?..

Answer / abhijt shinde

select MIN(salary) from Employees
where salary IN
(Select Top 3 salary from Employees order by salary desc)

Select Top 1 salary from Employees where salary
Not IN(select Top 1 salary from Employees order by salary Desc)
order by salary Desc

Is This Answer Correct ?

0 Yes

1 No

Find out the 3rd highest salary?..

Answer / arindam

select min(sal) from
(
select sal from
(
select distinct sal from emp order by sal desc
)
where rownum<=3
)
where rownum <4

Is This Answer Correct ?

5 Yes

7 No

Find out the 3rd highest salary?..

Answer / srikanth

select * from (select e.*,rank() over(order by salary desc
nulls last) sal_rnk from employee e)where sal_rnk=3;

Is This Answer Correct ?

3 Yes

5 No

Find out the 3rd highest salary?..

Answer / vishal beri

Select ename from emp e where 2=(select count(distinct(Sal))
from emp where sal>e.sal)

Is This Answer Correct ?

3 Yes

5 No

Find out the 3rd highest salary?..

Answer / suneel

select level,max(sal)from af where level=3 connect by prior
sal>sal group by level;

Is This Answer Correct ?

8 Yes

11 No

Post New Answer