how to find nth highest salary
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 table value parameters (tvp)?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What are cursors in ms sql server?
What is schemabinding a view?
Tell me what are cursors and when they are useful?
where the connection string store in the database
What is rtm version in sql server?
Explain what is sql server english query?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Give an example of SQL injection attack ?
Characterize join and name diverse sorts of joins?
What is SQL Azure?
What are diverse clauses that form a part of sql?
what's the difference between delete table and truncate table commands? : Sql server database administration
What is precedence constraint?