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

What is difference between group by and partition by?

1043

What is the reports view in oracle sql developer?

959

How you improve the performance of sql*loader? : aql loader

999

How do I filter in sql profiler?

988

Why do we need databases?

1028

What is replication id?

923

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2559

Does pdo prevent sql injection?

922

What is sql keyword?

983

Are subqueries better than joins?

959

Why self join is used in sql?

966

How can a pl sql block be executed?

934

What is secondary key?

921

How do you update a table in sql?

968

How many subqueries can be nested in a statement?

974