Select Salary From Employee Where rowid = n Order By Salary Desc;

how to find nth highest salary

Question Posted / divya

Answer Posted / divya

Select Salary
From Employee
Where rowid = n
Order By Salary Desc;

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

how many bits ip address consist of? : Sql server database administration

944

What are advantages of ssrs or why we should use ssrs?

145

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

1076

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.

2116

What are the types of indexes?

1133

How to change the system date and time from SQL Plus Terminal ?

1276

last function used in MS Access to convert sql what function will use in sql

2114

What are scheduled tasks in sql server?

1148

What is row_number()?

1053

How to convert binary strings into integers in ms sql server?

1082

Does order by actually change the order of the data in the tables or does it just change the output?

1208

Why should one not prefix user stored procedures with ‘sp_’?

1100

What is history table in sql server?

1036

What is SQL Azure?

107

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

989