select * from employee.e1 where (n-1) = ( select (distinct b.salary ) from

how to find nth highest salary

Question Posted / ravikiran

Answer Posted / ravikiran

select * from employee.e1 where (n-1) =
( select (distinct b.salary ) from employee.e2 where e1.salary > e2.salary

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is sub-query in sql server?

1261

What are different types of subquery?

1311

Explain log shipping?

1078

How to create an multi-statement table-valued function?

1049

How do I manually uninstall an instance of sql server 2016?

1082

Tell me what are cursors and when they are useful?

994

Define union, union all, minus, intersect?

1035

How to verify a user name with sqlcmd tool?

1122

What is clustered primary key?

1084

Is it possible to update the views? If yes, how, if not, why?

1089

What are the diifferences between the ms sql server vs mysql?

1240

Explain how to maintain a fill factor in existing indexes?

1039

What is dirty read?

1135

How do you delete duplicate records in sql server?

1127

Tell me what is normalization? Explain different forms of normalization?

1075