Find out the 3rd highest salary?
- 51 Answers
- 66378 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
How do you take the union of two tables in sql?
How does one use sql*loader to load images, sound clips and documents? : aql loader
What is on delete restrict?
What is sqlca in db2?
how many tables will create when we create table, what are they? : Sql dba
What are procedures used for?
Why do we need cursor in pl sql?
Explain sql data types?
Define union, minus, union all, intersect ?
What is 19 null in sql?
How to load data with sql*loader?
How to revise and re-run the last sql command?
what is a database transaction? : Sql dba
how to create a new view in mysql? : Sql dba
Explain autonomous transaction.
