SELECT NAME ,SAL 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 / raju

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

Answer Posted / raju

SELECT NAME ,SAL FROM employee WHERE
SAL=(SELECT MAX(sal)from employee )

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a collation?

1038

List few advantages of stored procedure.

927

What is in place upgrade in sql server?

990

How many replicas are maintained for each SQL Azure database?

140

What is mssql?

931

What are the different types of sql server replication? : sql server replication

1159

Explain the cursor lock types?

983

What is stored in the mssqlsystemresource database? : sql server database administration

988

What are types of storage modes? : sql server analysis services, ssas

986

What security features are available for stored procedure?

990

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1034

How to change a login name in ms sql server?

1026

Explain can SSRS reports Cache results?

149

What do you understand by replication in sql server? Mention the different types of replication in sql server.

895

What is instead of trigger sql server?

932