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

How many sql statements are used? Define them.

776

How do I order by ascending in sql?

741

What is a Mapplet?

827

Can you selectively load only those records that you need? : aql loader

776

How to run sql statements through the web interface?

730

What is scalar data type in pl sql?

788

What is a sql select statement?

766

Is it possible for a table to have more than one foreign key?

776

What are joins in sql?

719

How do you create a db file?

715

Is microsoft sql free?

778

what is primary key? : Sql dba

713

What do you mean by stored procedures? How do we use it?

714

What is microsoft t sql?

678

How delete all records from table in sql?

722