Find out the 3rd highest salary?

Answers were Sorted based on User's Feedback



Find out the 3rd highest salary?..

Answer / a.jyothsna

select a.sal
from emp a
where 3=(select distinct(count(b.sal))
from emp b
where a.sal<=b.sal)

Is This Answer Correct ?    100 Yes 45 No

Find out the 3rd highest salary?..

Answer / kaushal kassi

select distinct a.sal
from employee a
where 3=(select count(distinct b.sal)
from employee b
where a.sal<=b.sal)

Is This Answer Correct ?    24 Yes 12 No

Find out the 3rd highest salary?..

Answer / srikanth

select q.sal
from emp q
where 3=(select distinct(count(b.sal))
from emp b
where q.sal<=b.sal)

Is This Answer Correct ?    17 Yes 10 No

Find out the 3rd highest salary?..

Answer / karna

Hi Friends,

to get the nth highest value of a column in a table,please
use the below simple query

select min(column) from table where column in(select top n
column from table)

any queries,mail me at karun84@gmail.com

Is This Answer Correct ?    9 Yes 2 No

Find out the 3rd highest salary?..

Answer / karna

Hi Friends,

sorry,last answer was wrong.
I have changed the query,check now

to get the nth highest value of a column in a table,please
use the below simple query

select min(column) from table where column in(select top n
column from table order by desc)

any queries,mail me at karun84@gmail.com

Is This Answer Correct ?    10 Yes 3 No

Find out the 3rd highest salary?..

Answer / surendra kumar dattatrey

Select * from Emp where Salary =
(Select max(Salary) from Emp where Salary <
(Select max(Salary) from Emp where Salary <
(Select max(Salary) from Emp where Salary <.....N))))

Is This Answer Correct ?    8 Yes 2 No

Find out the 3rd highest salary?..

Answer / abhay

select distinct(sal) from emp a where 3=(select
count(distinct(sal) from emp b where a.sal<=b.sal);


somebody tell me he logic....!

Is This Answer Correct ?    6 Yes 1 No

Find out the 3rd highest salary?..

Answer / sachin

select distinct(sal) from employee order by sal desc limit 2,1;

Is This Answer Correct ?    5 Yes 0 No

Find out the 3rd highest salary?..

Answer / anjali

select min(column_name) from table where column in(select
top n
column_name from table order by column_name desc)

Is This Answer Correct ?    4 Yes 1 No

Find out the 3rd highest salary?..

Answer / amit singh

Empsal table data
700
500
100
900
400
200
600
750


query to find second highest salary from table Empsal

mysql>select distinct(max(e.salary)) from Empsal e
>where e.salary in(
>select e1.salary from Empsal e1 where e1.salary<
(select max(salary) from Empsal));

Output=750



query to find third highest salary from table Empsal


mysql>select distinct(max(e.salary)) from Empsal e
>where e.salary in(
>select e1.salary from Empsal e1 where e1.salary<
>(select max(e1.salary) from Empsal e1
>where e1.salary IN(
>select e2.salary from Empsal e2 where
>e2.salary<(select max(salary) from Empsal))));
Output=700

RUN THE QUERY THEN ARG
amitsing2008@gmail.com(amit is back)

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What can you do with pl sql?

0 Answers  


Explain some predefined exceptions.

0 Answers  


What are the sql versions?

0 Answers  


Explain the uses of control file.

0 Answers  


how will i became good database developer?

1 Answers  






Can we use having without group by in sql?

0 Answers  


Define tables and fields in a database

0 Answers  


What is scalar function?

0 Answers  


What is the use of sqlerrd 3?

0 Answers  


how can stop the sequence with mention the max value and with out mention the max value

1 Answers   Zensar,


Mention what does the hierarchical profiler does?

0 Answers  


what is the difference between to_char and to_date functions?

10 Answers   Infosys,


Categories