Find out the 3rd highest salary?
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
How to create your own reports in sql developer?
what is msql? : Sql dba
Why procedure is used in sql?
What mean sql?
How to use boolean type in select statement?
What are the different tcl commands in sql?
Which one is better sql or oracle?
What is bind variable in pl sql?
What is trigger in sql and its types?
What is difference between table and view?
What is the use of sql trace?
what are all the different normalizations? : Sql dba
What operating systems are supported by oracle sql developer?
What is the function that is used to transfer a pl/sql table log to a database table?
Differentiate pl/sql and sql?