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

Explain the significance of the & and && operators in pl sql.

1011

What is program debugging?

1259

Does truncate need commit?

951

What's the difference between a primary key and a clustered index?

993

Where do we use pl sql?

1005

How subquery works in sql?

1075

How do you declare a user-defined exception?

1031

how to create a new table in mysql? : Sql dba

997

How do you change a value in sql?

1023

Is null operator in sql?

1048

What is graph sql?

998

What is the best sql course?

990

What are the uses of merge?

1172

Can we use rowid as primary key?

995

What does select top 1 do in sql?

1105