n th Highest salary select salary from test t1 where n-1=(select COUNT (

how to find nth highest salary

Question Posted / sanwar hudda

Answer Posted / sanwar hudda

n th Highest salary

select salary from test t1 where n-1=(select COUNT (*) from
test

where salary > t1.salary )

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is raiseerror? What is raiseerror?

1141

Can you explain what is indexed view? How to create it?

908

what's sql server? : Sql server database administration

1000

how to avoid cursors? : Sql server database administration

971

what is a mixed extent? : Sql server administration

1104

How ssrs maintain security?

1086

What is the difference between DATETIME2 and DATETIME?

1080

Explain external key management in sql server 2008

889

Define Wed Edition in SQL Azure?

100

What happens if null values are involved in boolean operations?

987

What is snapshot parameter in ssrs?

150

How can I check if a view exists in a sql server database?

1038

What is an expression in ms sql server?

1076

What is conditional split?

1081

Do you know query execution plan?

1179