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 a new view in mysql? : Sql dba
Can a primary key be a foreign key?
How can you get sql*loader to commit only at the end of the load file? : aql loader
what is a database? : Sql dba
What does pl sql developer do?
What is the difference between local variables and global variables?
What does select * from mean in sql?
What is the difference between a primary key and a clustered index?
What is the difference between join and natural join?
Where is sql database stored?
What are the types of join and explain each?
What does count (*) mean in sql?
What happens when a trigger is associated to a view?
What is record type in pl sql?
What are keys in sql?