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 optimization and its types?

1037

Can you explain full-text query in sql server?

1057

What are the restrictions that views have to follow? : SQL Server Architecture

1058

Explain error and transaction handling in sql server?

1060

Explain what is row_number function?

1081

Can you edit the .rdl code associated with a linked report?

168

What is the process of indexing?

1048

What is unique key constraint?

1116

What is difference between delete and truncate commands?

1169

How is SQL Azure different than SQL server?

225

Explain what are the database objects? : SQL Server Architecture

1141

What is faster join or union?

1314

Which is better statement or preparedstatement?

982

What do you mean by 'normalization'?

1121

What's the information that can be stored inside a bit column?

1067