SELECT ename,MAX(sal) FROM EMP GROUP BY ename;

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

Question Posted / suresh kumar somayajula

SELECT ename,MAX(sal)
FROM EMP
GROUP BY ename;

Is This Answer Correct ?

9 Yes

15 No

Please Help Members By Posting Answers For Below Questions

How do you use collections in procedure to return the resultset?

2184

explain mysql aggregate functions. : Sql dba

941

What is the difference between local variables and global variables?

1071

What is a behavioral trigger?

932

How many types of cursors are available in pl/sql?

1045

What is a field in a database?

1006

how tsql statements can be written and submitted to the database engine? : Transact sql

924

Define commit, rollback and savepoint?

979

Is oracle sql free?

928

when is the use of update_statistics command? : Sql dba

972

What are synonyms in sql?

932

what is a table in a database ? : Sql dba

991

What is keys and its types?

1022

What is record variable?

925

How do sql databases work?

947