how to find nth highest salary
Answer Posted / ganesh prasad
all are not working properly incase repeat salary
this one is correct to finding 4th highest salary try run
your system then call me 9438183722
select min(deptsal) from dept where deptsal in ( select
distinct top 4 deptsal from dept order by deptsal desc)
| Is This Answer Correct ? | 5 Yes | 14 No |
Post New Answer View All Answers
what kind of lan types do you know? : Sql server database administration
What is CTE in SQL
What is indexed view? How to create it?
How do I save a stored procedure in sql server?
How can you append an identity column to a temporary table?
What is update_statistics command?
Explain the commands in sql server?
what are isolation levels? : Sql server database administration
What are the difference between clustered and a non-clustered index?
Can we use where clause with group by?
what are defaults? : Sql server database administration
What are scalar functions?
What do you know about system database? : SQL Server Architecture
What are the common performance issues in sql server?
What is bookmark link in ssrs?