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

What is a constraint? Tell me about its various levels.

1142

Is primary key clustered index?

940

Describe sql comments?

1013

what is the stuff function and how does it differ from the replace function? : Sql dba

1031

What programs use sql?

983

Mention what are the benefits of pl/sql packages?

1062

Enlist some predefined exceptions?

1041

What is blind sql injection?

1048

What are pl sql data types?

998

What is ttitle and btitle?

1051

Is nosql faster than sql?

1002

What is cursor in pl sql with examples?

1013

Why does sql need a server?

1022

What is the left table in sql?

954

How many scalar data types are supported in pl/sql?

1033