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

Can we have two clustered index on a table?

1025

What are all the different normalizations?

1033

What is rename command in sql?

1036

What is a boolean in sql?

983

Why do we use cursors?

990

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1017

Can we use pl sql in sql server?

1084

how do you login to mysql using unix shell? : Sql dba

1081

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1155

what are the advantages and disadvantages of views in a database? : Sql dba

1043

what is data manipulation language? : Sql dba

1021

Define a temp table?

1020

Explain sql data types?

1101

Explain the update statement in sql

994

What is difference between pls_integer and integer?

965