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 are different replication agents and what's their purpose? : sql server replication

1008

What is log ldf?

976

What stored by the msdb?

994

Which tcl commands are available on the sql server?

1076

what is blocking? : Sql server database administration

1033

Can You Use Data Mining Models In Ssrs?

145

How is foreign key related to primary key?

966

What does dml stand for?

944

What is a view and what are its advantages?

1110

Where sql server user names and passwords are stored in sql server? : sql server database administration

1048

Why do you want to join software field as you have done your BE in Electronics?

2137

Explain the difference between delete,drop and truncate in SQL Server?

1093

What is trigger explain with program?

975

Explain about unique identifier data type in sql server?

907

What is the need for indexing?

943