Select * from Employee where salary in(select max(salary) from Employee)

From an Employee table, how will you display the record
which has a maximum salary?

Question Posted / sharmila

Answer Posted / sharmila

Select * from Employee where salary in(select max(salary)
from Employee)

Is This Answer Correct ?

13 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Is sql a backend?

545

what are the nonstandard string types? : Sql dba

601

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

538

What is sql partition?

546

Explain what is a database?

645

How to rename a table?

556

how to create a new table by selecting rows from another table in mysql? : Sql dba

559

What are all the ddl commands?

624

How can we debug in PL/SQL?

655

What is cross join example?

549

What are sql data types?

546

What are the different types of constraints?

561

How many sql databases can you have on one server?

590

How do I find duplicates in two columns?

548

What is the use of sqlerrd 3?

519