select name,sal from employee where sal in(select top 5 sal from employee o

An employee table, with the columns id, name, sal and dob.
Query to select emp names of all highest salaries(there are
4-5 people having the same salary which happens to be the
highest).

Question Posted / anil

9 Answers
16196 Views
ADP, I also Faced
E-Mail Answers

Answer Posted / anil

select name,sal from employee where sal in(select top 5 sal from employee order by sal desc)

Is This Answer Correct ?

7 Yes

7 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are click through reports?

142

Mention the different types of triggers?

1119

How to get a list of all tables with "sys.tables" view in ms sql server?

1036

What is deploy, process and build? : sql server analysis services, ssas

1112

What is plan freezing?

973

What is the difference between Clustered and Non-Clustered Index?

1059

How to concatenate two strings in SQL Server.

1152

Mention what are the different types of ssrs reports?

152

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

996

What is a subquery in a select query statement in ms sql server?

1133

What is sql injection? How to protect against sql injection attack?

1001

What is mean by dml?

1017

What is function of ROLLUP ?

1086

What is triggers and its types?

1009

What is a functions and types in sql server?

1089