how to find nth highest salary
Answer Posted / mangalesh porwal
HERE N IS THE NO WHICH HIGHEST NO U WANT..........
IT SURELY WORKS.....
SELECT TOP 1 * FROM (SELECT TOP N * FROM (SELECT ROLLNO FROM TABLE_NM ) AS D ORDER BY ROLLNO DESC) AS P ORDER BY ROLLNO
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain where clause?
How do I find query history in sql server?
You want to implement the one-to-many relationship while designing tables. How would you do it?
Does a server store data?
How to generate create procedure script on an existing stored procedure?
What happens if null values are involved in boolean operations?
Do you know how to send email from database?
How to create a simple stored procedure in ms sql server?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What are system databases into sql server (2005/2008) : sql server database administration
What does executeupdate return?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
What is entity data services?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
Find first and last day of current month in sql server