Interested to Buy Any Domain ? << Click Here >> for more details...
how to find nth highest salary
- 103 Answers
- 182117 Views
- Cognizant, IBM, NexGen, Oracle, I also Faced
- E-Mail Answers
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
Can we delete data from a view?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
What is the name of the Database which IBM mainframe uses?
Explain mixed authentication mode of sql server?
What are cascading parameters in ssrs reports?
How to get a list of columns in a view using the "sp_help" stored procedure?
List the different normalization forms?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
How to drop an existing schema in ms sql server?
Why Master database is required?
Can we add a cpu to sql server?
How to execute a sql statement using odbc_exec()?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
What is the chart in report?
