The Genral answer which can work on any SQL:- select salary from emp

how to find nth highest salary

Question Posted / rahul tripathi

103 Answers
178649 Views
Cognizant, IBM, NexGen, Oracle, I also Faced
E-Mail Answers

Answer Posted / rahul tripathi

The Genral answer which can work on any SQL:-

select salary from emp e1 where (n-1)=(select count(*)
from emp where salary > e1.salary )

Rahul Tripathi

rahultripathi@inkanpur.com

Is This Answer Correct ?

249 Yes

76 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Does transparent data encryption provide encryption when transmitting data across the network?

980

How to enable/disable indexes?

1011

Define views.

960

What is postgresql server?

937

What will be the maximum number of index per table?

950

How to create a view using data from another view?

902

What is sub-query in sql server?

1139

What happens if ntwdblib.dll is missing on your machine?

1097

What does COMMIT command do?

1006

What are wait types?

1014

How is sql server used?

905

where the connection string store in the database

2014

Explain about link server in sql server?

996

What are the types of ssrs?

139

What is db stored procedure?

809