Interested to Buy Any Domain ? << Click Here >> for more details...
how to find nth highest salary
- 103 Answers
- 178771 Views
- Cognizant, IBM, NexGen, Oracle, I also Faced
- E-Mail Answers
Answer Posted / lakshmi reddy
To get nth highest salary from Employee table:
select * from Employee e where n=(select COUNT(distinct sal)
from Employee e2 where e2.Sal>e.Sal)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the purpose of a table?
What are the benefits of normalization?
What is difference between group by and having?
How to deploy the Report?
What are the advantages to use stored procedures?
Define Wed Edition in SQL Azure?
How to perform key word search in tables?
what are cursors? : Sql server database administration
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
What is wrong with sql server client libarary dll, ntwdblib.dll?
What is service broker? : sql server database administration
How to rebuild master databse?
how would you improve etl (extract, transform, load) throughput?
Define model database?
What are data driven subscriptions?
