how to find nth highest salary
Answer Posted / manshul
select * from employee e, (select salary, rownum rn from
(select distinct salary from employee order by salary desc))
T where T.sal= e.sal and T.rn = 4
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what is a live lock? : Sql server database administration
how can a database be repaired? : Sql server administration
what are user defined datatypes and when you should go for them? : Sql server database administration
1 01 101 01010
What is a periodical index?
When you should use a low fill factor?
Explain sql server authentication modes?
What happens on checkpoint?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What is the use of =,==,=== operators?
How to drop existing indexes in ms sql server?
What are the difference between primary keys and foreign keys?
What is the server name in sql server?