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 global cursor can be declare with dynamic trigger ?

2192

Can we join same table in sql?

1003

How do you take the union of two tables in sql?

972

What is the sql query to display the current date?

1032

what is schema? : Sql dba

1030

how to write date and time literals? : Sql dba

947

What is the clause we need to add in function body to return variable?

1003

how to convert character strings to numeric values? : Sql dba

1083

How many types of relationship are there?

1021

Can we use views in stored procedure?

1020

Is inner join same as self join?

1107

What is a nested table in word?

948

What is the difference between nvl function, ifnull function, and isnull function?

1089

Give the order of sql select?

1124

what is online transaction processing (oltp)? : Sql dba

982