select name from employee where sal = (select max(sal) from employee)

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 / reshu singhal

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

Answer Posted / reshu singhal

select name from employee where sal = (select max(sal) from
employee)

Is This Answer Correct ?

4 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can you know if the row fetched from cursor is still valid in underlying table?

1048

What is the index requirement in SQL Azure?

Determine when an index is appropriate?

1132

If the job running very slow what is the action you do

1942

How to defragment table indexes?

1040

What is table join?

1172

What is user-defined function?

1035

What is a data collection table?

1051

Write SQL queries on Self Join and Inner Join.

1218

How do I run sql server 2014?

1055

What are the disadvantages of primary key and foreign key in SQL?

1154

What is difference between commit and rollback when used in transactions?

1019

What is sql server used for?

1101

What is etl - extraction, transformation, and loading?

961

How to generate create function script on an existing function?

1180