how to find nth highest salary
- 103 Answers
- 163937 Views
- Cognizant, IBM, NexGen, Oracle, I also Faced
- E-Mail Answers
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
What is the difference between grant and with grant while giving permissions to the user?
How do you test your database? : sql server database administration
how to trace the traffic hitting a sql server? : Sql server database administration
What is the need for indexing?
Why functions are used in sql server?
What is GUID in sql server?
What is a trace frag? Where do we use it?
What are the disadvantages of indexes?
What is row_number()?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
Detail about the hardware which is supported by SQL server?
What is a virtual table in sql?
What is clustered primary key?
How many types of local tables are there in sql server?
how you can list all the tables in a database?
