How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
Answer Posted / ranjith
Select Max(Salary) from emp_database where Salary < (Select
Max(Salary) from emp_database)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is compression - row-level and page-level compression?
How to get the definition of a stored procedure back?
What is 1nf normalization form?
Comment,Datatypes are unlimited
What's new in sql management studio for sql server? : sql server management studio
What is self contained scalar sub query?
What is exclusive locks?
What is nonclustered index with included columns ?
Explain Capacity planning to create a database? and how to monitor it?
Do you know the capabilities of cursors?
What is compound operators?
explain what is raid and what are different types of raid configurations? : Sql server database administration
What is self contained multi valued query?
How you provide security to cube? : sql server analysis services, ssas
How do you clear a log file?