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 are reports usually used for?

1023

What are conditional predicates?

1059

What is oracle sql developer?

1047

What is difference between left and right outer join?

985

How can I get the number of records affected by a stored procedure?

1065

how to get help information from the server? : Sql dba

939

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1079

What are hotfixes and patches?

946

what is transaction? : Sql dba

1007

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1001

write an sql query to find names of employee start with 'a'? : Sql dba

1027

what are the drivers in mysql? : Sql dba

1019

Where not exists in sql?

978

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1065

How delete all records from table in sql?

977