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
16202 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 sql server? : Sql server database administration

997

What is an active database?

1018

What according to you is the difference between mysql and sql server performance?

1093

Difference between LEN() and DATALENGTH() in sql server ?

1120

What is data source view or dsv? : sql server analysis services, ssas

1007

What is the difference between char, varchar and nvarchar?

1026

What is the osql utility?

978

Can we use trigger new in before insert?

926

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

1065

How to convert a table data in XML format in sql server?

2547

What is the purpose of a table?

961

What is 2nf in normalization?

1005

What does the on update no action do?

1033

How to handle error or exception in sql?

987

What encryption security is available in sql azure?

101