select * from employee where sal=(select max(sal) from employee);

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

Question Posted / aruna parulekar

Answer Posted / aruna parulekar

select * from employee where sal=(select max(sal) from
employee);

Is This Answer Correct ?

14 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is data control language?

528

Which join condition can be specified using on clause?

512

What is difference between nchar and nvarchar?

536

Is sql free?

497

What does a pl/sql package consist of?

512

What is before and after trigger?

516

Explain constraints in sql?

569

What are pl/sql cursor exceptions?

569

what are the differences among rownum, rank and dense_rank? : Sql dba

536

Explain how can you save or place your msg in a table?

593

How do I start pl sql?

490

What are the types of functions in sql?

558

How many indexes can be created on a table in sql?

494

Can we rollback after truncate?

559

What is trigger explain it?

547