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

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

Question Posted / ahmad nazmi

Answer Posted / ahmad nazmi

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

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Can we use views in stored procedure?

1035

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

1086

Can we create clustered index without primary key?

968

What is equi join in sql?

1082

How do you modify a trigger?

930

Can triggers stop a dml statement from executing on a table?

1101

How does cross join work?

961

Can we create foreign key without primary key?

987

Which data type is a composite type?

991

What is a system versioned table?

992

What is rename command in sql?

1039

Why do we create views in sql?

1155

discuss about myisam key cache. : Sql dba

1024

What is sqlexception in java?

999

How do you modify a table in sql?

1129