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

Are views faster than queries?

1045

Why truncate is used in sql?

1043

what are properties of a transaction? : Sql dba

1139

how to drop an existing table in mysql? : Sql dba

1092

What is composite data type in pl sql?

1170

What is cartesian join in sql?

1196

What is sql character function?

1151

What is an invalid partition table?

1067

Is postgresql a server?

1114

What are instead of triggers?

1101

what does it mean to have quoted_identifier on? : Sql dba

1181

Why use triggers in sql?

1013

What are the different types of dbms?

1067

What is #table in sql?

1182

Show how functions and procedures are called in a pl/sql block.

1188