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 ?

4 Yes

11 No

Please Help Members By Posting Answers For Below Questions

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

972

What is normalisation and its types?

974

What is nosql db?

936

How do I remove duplicates in two columns?

1011

is it possible to pass an object or table to a procedure as an argument?

1088

What are basic techniques of indexing?

1346

What is a null value?

1104

What is compound trigger?

995

How much does sql cost?

955

How many developers work on postgresql?

932

what is csv? : Sql dba

959

What are the types of triggers in sql?

1043

Can 2 queries be executed simultaneously in a distributed database system?

1104

What is optimistic concurrency control? : Transact sql

958

What is AUTH_ID and AUTH_USER in pl/sql ?

2158