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 does postgresql compare to "nosql"?
What is a recursive stored procedure?
how to create a table index in mysql? : Sql dba
What is data control language?
What is a constraint?
How do I order by ascending in sql?
Is id a reserved word in sql?
What is a function in oracle pl sql?
What are different types of statements supported by sql?
What are operators available in sql?
what are the t string functions available in tsql? : Transact sql
How many sectors are in a partition?
What are the features of pl sql?
What is the best free sql database?
how can we know the number of days between two given dates using mysql? : Sql dba