how to find nth highest salary
Answer Posted / ganesh prasad
all are not working properly incase repeat salary
this one is correct
select min(deptsal) from dept where deptsal in ( select
distinct top 4 deptsal from dept order by deptsal desc)
| Is This Answer Correct ? | 6 Yes | 14 No |
Post New Answer View All Answers
How to create function without parameter in sql server?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
difference between Clustered index and non clustered index ?
How sql server enhances scalability of the database system?
Do you know what is normalization of database? What are its benefits?
What do you understand by recursive stored procedures?
What is ms sql server triggers?
Explain what is the main purpose of having conversation group?
What are the 3 types of schema?
Relational calculus is what type of language?
What is difference between delete & truncate commands?
What is difference between materialized view and view?
Do you know sql server 2008 backup compression?
How to receive output values from stored procedures?
What is meant by datasource?