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 trigger in flip flop?

959

What is a dynamic query?

973

What is rtm stands for?

1023

what is a field in a database ? : Sql dba

991

How do I order columns in sql?

914

What company owns postgresql?

963

Can there be more than one function with a similar name in a pl/sql block?

927

Is pl sql a scripting language?

971

What is secondary key?

882

How much does sql certification cost?

1017

When sql appeared?

1025

what is the difference between join and union? : Sql dba

1030

What is procedure and function?

924

What is package in pl sql with an examples?

972

Why is a trigger used?

890