how to find nth highest salary
Answer Posted / nidhish
replace the N with wat ever number u want
select min(salary) from employee where salary in ( select
distinct top N salary from employee order by salary desc)
| Is This Answer Correct ? | 26 Yes | 17 No |
Post New Answer View All Answers
What is the difference between varchar and nvarchar?
Explain why variables called the most powerful component of ssis?
What is a domain constraint give an example?
Explain the various types of concurrency problem?
Explain having clause and where clause?
What is temporal table?
Explain about Normalization?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
What is always encrypted?
application server is slow what may be the problem
What are policy management terms?
What is the difference between DataRow.Delete() and DataRow.Remove()?
When is update_statistics command used?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is difference between equi join and inner join?