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
15814 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

How to find related tables in sql server?

870

Can you explain the disadvantages/limitation of the cursor?

906

What are functions in the sql server?

1126

What stored by the tempdb ? : sql server database administration

1005

How to create a dml trigger using create trigger statements?

975

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

854

How are the exceptions handled in sql server programming?

996

How do I delete a sql server database?

984

What are the benefits and tasks of object explorer? : sql server management studio

1113

What is stretch database in sql server?

1025

List few advantages of stored procedure.

923

Is it possible to have clustered index on separate drive from original table location?

905

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

1069

What is the need for indexing?

887

Find nth lowest salary or get nth lowest salary?

965