how to find nth highest salary
- 103 Answers
- 167963 Views
- Cognizant, IBM, NexGen, Oracle, I also Faced
- E-Mail Answers
Answer Posted / udathayadav
select * from tablename.aliasname where nth=select
count(sal) from tablename where aliasname.sal<=sal
| Is This Answer Correct ? | 38 Yes | 26 No |
Post New Answer View All Answers
what are the new features in SSRS?
What is dbcc? Give few examples.
What are the security related catalog views? : sql server security
what is a transaction? : Sql server database administration
What is normalization of database? What are its benefits?
What is a rollup clause?
What is normalization? Describe its different types.
What is the purpose of the tempdb database?
Explain difference between cross join and full outer join?
What is an identity?
How to replace given values with null using nullif()?
Ways to improve the performance of a SQL Azure Database?
What do I need to start working with sql studio? : sql server management studio
What is the Difference Between Primary and Foreign Key?
What is a hint?
