select salary from Emp a where 4 = (select count(distinct (salary)) from E

Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed)

Question Posted / v rajkumar

Answer Posted / v rajkumar

select salary from Emp a where 4 = (select count(distinct
(salary)) from Emp b where b.salary>= a.salary)

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is a deadlock and what is a live lock?

1003

How many types of attribute relationships are there? : sql server analysis services, ssas

1079

How you can move data or databases between servers and databases in sql server?

1051

How to modify existing triggers using "alter trigger"?

1017

What is application role in sql server database security? : sql server security

1058

What are views in ms sql server?

1085

What is cross join in sql server joins?

1143

What are trace flags?

1033

How real and float literal values are rounded?

1158

What is named query? : sql server analysis services, ssas

967

How can we determine what objects a user-defined function depends upon?

1015

What is a document index?

1029

What is the difference between online clustering and Offline clustering?

2419

What is built-in function?

1009

What is a data collection table?

1008