find out the third highest salary?
Answer Posted / ashok naik
In Sql server:
Select top 1 ThirdHighest.salary from(
Select distinct top 3 salary from employee order by salary
desc) as ThirdHighest
--example for 4th highest salary in above query put 4
inplace of 3
--example for 5th highest salary in above query put 5
inplace of 3
--and so on for nth highest
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How to convert raw data type into text in oracle? Explain
How to create id with auto_increment on oracle?
What is the Tune Query
Explain integrity constraint?
Explain the importance of .pll extension in oracle?
What is raw datatype in oracle?
What is not equal to in oracle?
How to delete a column in an existing table in oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
What is the max number of columns in an oracle table?
What are the different oracle database objects?
What is the relation of a user account and a schema?
How do I manually create a database in oracle?