select name,max(sal) from emp group by name

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 / kalyan

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

Answer Posted / kalyan

select name,max(sal) from emp group by name

Is This Answer Correct ?

6 Yes

8 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to delete a database in ms sql server?

1325

Explain index in sql server?

1068

How many primary keys are possible in a table?

966

How global temporary tables are represented and its scope?

1017

What are different types of raid levels?

1244

Explain hostprotectionattribute in sql server 2005?

1075

What are xml indexes?

1010

How to install sql server 2005 express edition?

1172

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

947

What is the architecture of ms sql reporting service?

1027

What is sql stored procedure?

1150

Write a SQL query in order to merge two different columns into single column?

1089

Mention what are the different types of ssrs reports?

158

What is the purpose of data source?

1093

How to test a dml trigger in ms sql server?

1118