select max(sal),ename from emp where sal=(select max(sal) from emp) group

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.

Question Posted / pramod janjirala

Answer Posted / pramod janjirala

select max(sal),ename from emp where sal=(select max(sal)
from emp) group by ename;

Is This Answer Correct ?

13 Yes

10 No

Please Help Members By Posting Answers For Below Questions

what is innodb? : Sql dba

1084

What is flag in sql?

1016

What is the difference between clustered and non-clustered index in sql?

986

What are character functions?

1072

What is use of package in pl sql?

992

which types of join is used in sql widely? : Sql dba

966

Why do we use joins?

1017

What is the sql query to display the current date?

1025

When is the explicit cursor used ?

1007

Why is pl sql used?

962

What is primary key and foreign key?

946

What are database links used for?

1028

What is a join query?

937

Which join is like inner join?

1005

How do I view a table in sql?

993