how to find nth highest salary
Answer Posted / pandian
select top 1 salary from (select distinct top 9 salary from
EmpMaster order by salary desc)a
Is This Answer Correct ? | 65 Yes | 88 No |
Post New Answer View All Answers
What are the purposes of floor and sign functions?
Explain active/passive and active/active cluster configurations?
What are clustered and non-clustered index?
How do you Implement SSIS Packages in your Project?
What is resultset concur_updatable?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What is dimension table? : sql server analysis services, ssas
Name 3 ways to get an accurate count of the number of records in a table?
How to replace the Query Result 'Null Value' with a text ?
How to find table changes in sql server?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
Do you know what is difference between stored procedure and user defined function?
What are the types of resultset?
Can binary strings be used in arithmetical operations?
Explain about Views?