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

Is left join inner or outer?

1014

What is the primary use of normalization?

1000

Can we change the table name in sql?

938

What is pl sql collection?

962

What is error ora-12154: tns:could not resolve the connect identifier specified?

1072

What is an invalid partition table?

1023

How subquery works in sql?

1067

What is pl sql block structure?

1034

What is the mutating table and constraining table?

1024

What is file based approach?

937

How do you bind variables in pl sql?

1093

What is the purpose of a sql?

974

Can variables be used in sql statements?

1029

What is the cause of mutating table error and how can we solve it?

1047

How do you sort in sql?

1022