how to find nth highest salary
Answer Posted / dewashish kumar pal
Select max(salary) from tablename where salary not in (select max(salary) from tablename);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
on line cluster can we make if yes tell me the procedure
what are the different stages of Report Processing?
What is a dataset and what are the different types of datasets?
What is database replication?
What is history table in sql server?
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
How to retrieve error messages using odbc_errormsg()?
What is outer join in sql server joins?
How will you go about resolving deadlocks?
What do we need queues in sql service broker?
What is parameterized reports in ssrs ?
Can you explain various data region available in ssrs with their use?
what's new in sql server 2016?
What are cursors and when they are useful?
What happens if the update subquery returns multiple rows in ms sql server?