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 plpgsql language?

977

How to make a copy values from one column to another in sql?

980

What is the main reason behind using an index?

964

What is sql analyzer?

958

What is #table in sql?

994

what are integrity rules?

963

How insert into statements in sql?

1007

How is data stored in sql?

1001

Define union, minus, union all, intersect ?

949

How to get help at the sql prompt?

1052

What are the advantages of sql?

1005

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1287

What is parallel hint?

1219

How is a PL/SQL code compiled?

1170

Can function return multiple values in sql?

984