how to find nth highest salary
Answer Posted / amit
Select salary
from employees
order by salary desc
limit n-1,1;
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
How to stop a loop early with break statements in ms sql server?
Are all views updatable ?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
What do you mean by 'normalization'?
What is auditing in sql server?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
Explain the truncate command?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
What is a Join and explain its types?
How to optimize stored procedures in sql server?
How we can compare two database data?
Can you roll back the ddl statement in a trigger?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
What is database replication?
Explain the commands in sql server?