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 / subrata sinha roy

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

Answer Posted / subrata sinha roy

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

Is This Answer Correct ?

4 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is query and its types?

959

what is the main function of a query parameter?

155

what is a correlated sub-query? : Sql server database administration

992

Explain trigger and trigger types?

1040

Do you know how to send email from database?

1053

How to edit table in sql server 2017?

984

Explain what is row_number function?

1085

How do I install only the client tools of sql server 2000?

1129

Is it possible to replicate data from sql server to oracle? : sql server replication

1140

What does COMMIT command do?

1123

Explain what is “asynchronous” communication in sql server service broker?

962

If a table does not have a unique index, can a cursor be opened on it?

961

Explain the microsoft sql server delete command?

1082

How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

1803

What is the difference between clustered and non-clustered indexes in ms sql server?

1059