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
75402 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 to create your own reports in sql developer?

1062

what is msql? : Sql dba

1043

Why procedure is used in sql?

1083

What mean sql?

1052

How to use boolean type in select statement?

1133

What are the different tcl commands in sql?

1224

Which one is better sql or oracle?

1013

What is bind variable in pl sql?

1102

What is trigger in sql and its types?

1107

What is difference between table and view?

1132

What is the use of sql trace?

1001

what are all the different normalizations? : Sql dba

1113

What operating systems are supported by oracle sql developer?

1011

What is the function that is used to transfer a pl/sql table log to a database table?

1064

Differentiate pl/sql and sql?

1125