Find out the 3rd highest salary?
- 51 Answers
- 62153 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
what is the stuff function and how does it differ from the replace function? : Sql dba
What is flag in sql?
What is the best partition size for windows 10?
how to load data files into tables with 'mysqlimport'? : Sql dba
what is a record in a database ? : Sql dba
How do I write a cron which will run a sql query and mail the results to agroup?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
what is the difference between clustered and non clustered index in sql? : Sql dba
what are the authentication modes in sql server? : Sql dba
How long does it take to learn pl sql?
Does postgresql run on the cloud?
What are local and global variables and their differences?
How do you modify a column in sql?
What is sqlite format?
What is sqlca in db2?
