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 / debjani chakraborty

Answer Posted / debjani chakraborty

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

Is This Answer Correct ?

58 Yes

2 No

Please Help Members By Posting Answers For Below Questions

how to write date and time literals? : Sql dba

528

what is a database transaction? : Sql dba

581

Is sql an operating system?

543

What is the difference between the sql*loader and import utilities? : aql loader

596

What is pl sql record in oracle?

563

What is a delimiter in sas?

539

Explain what is rdbms?

580

What is sharding in sql?

557

How to create your own reports in sql developer?

533

How delete all records from table in sql?

548

Is there a 64 bit version of ssms?

511

What is join view in sql?

508

How do I filter in sql profiler?

534

What is interval partition?

539

Why stored procedure is faster than query?

513