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 application trigger?

966

Why left join is used in sql?

941

What is form and report?

940

What is denormalization in a database?

1011

Is sql open source?

926

What is right join sql?

935

Does truncate release storage space?

1039

What is replication id?

900

Why does sql need a server?

1009

Can you join views in sql?

916

What do we need to check in database testing?

980

What is cursor in pl sql?

1077

explain normalization concept? : Sql dba

1013

What is posting?

1010

how is myisam table stored? : Sql dba

1016