Select * from Emp where Salary = (Select max(Salary) from Emp where Salary

Find out the 3rd highest salary?

Question Posted / surendra kumar dattatrey

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How does postgresql compare to "nosql"?

1018

What is a recursive stored procedure?

1160

how to create a table index in mysql? : Sql dba

1036

What is data control language?

973

What is a constraint?

998

How do I order by ascending in sql?

990

Is id a reserved word in sql?

1134

What is a function in oracle pl sql?

1014

What are different types of statements supported by sql?

1147

What are operators available in sql?

1024

what are the t string functions available in tsql? : Transact sql

992

How many sectors are in a partition?

1062

What are the features of pl sql?

1049

What is the best free sql database?

1041

how can we know the number of days between two given dates using mysql? : Sql dba

1027