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 pl sql still used?

504

What are the basic techniques of indexing?

563

What type of join is sql join?

525

What is set serveroutput on?

637

how does a local variable is defined using t-sql? : Transact sql

537

How exception handling is done in advance pl/sql?

491

What is the use of sqlerrd 3?

517

Explain polymorphism in pl/sql.

635

Does sql full backup truncate logs?

525

How many types of cursors are available in pl/sql?

581

What are the events on which a database trigger can be based?

586

What's the difference between a primary key and a clustered index?

509

What is a data manipulation language?

568

What are the key differences between SQL and PL SQL?

622

What is the difference between sql and isql*plus?

507