select * from emp e,(select max(sal) sal from emp)a

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

Question Posted / kavitha nedigunta

Answer Posted / kavitha nedigunta

select * from emp e,(select max(sal) sal
from emp)a
where e.sal= a.sal;

select * from emp
where sal in(select max(sal) from
emp);

Is This Answer Correct ?

29 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is the use of function "module procedure" in pl/sql?

1134

What is string data type in sql?

1050

What are tables and fields?

973

What is group function in sql?

964

What are sql commands?

935

How do I view a table in sql?

948

what are the authentication modes in sql server? : Sql dba

998

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1033

What is column?

940

How do you exit in sql?

1062

who introduced sql?

948

What is sqlca in powerbuilder?

954

Is left join same as join?

937

what are the advantages of using stored procedures? : Sql dba

1059

Can a table contain multiple primary key’s?

1042