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 cascade in sql?

1009

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

1097

What is sql*plus?

1116

Does asenumerable execute the query?

1092

How to create an array in pl/sql?

1115

What is the benefit of foreign key?

1062

Can we call stored procedure in function?

995

What is data manipulation language?

1223

how to escape special characters in sql statements? : Sql dba

1079

What are the benefits of pl sql?

1172

How many tables can you join in sql?

1000

What is the use of & in pl sql?

1093

what are the 'mysql' command line options? : Sql dba

1128

Can we insert data in view?

1005

What are predefined functions in sql?

1099