Interested to Buy Any Domain ? << Click Here >> for more details...
how to find nth highest salary
- 103 Answers
- 179651 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
Explain what are page splits? : SQL Server Architecture
What is the primary use of the model database?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
Does partitioning improve performance sql server?
what is a deadlock? : Sql server database administration
What is the data type of time?
Explain hostprotectionattribute in sql server 2005?
query processing
How you can get the list of largest tables in a database?
What is the usage of sign function?
What does dml stand for?
How to assign null values to variables or columns?
How many instances per computer are there in sql server 2000?
What is an expensive query?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
