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 ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is inner join in sql?

775

what is data control language? : Sql dba

750

Can we delete column in sql?

770

What is sql*plus?

775

Does sql backup shrink transaction log?

737

Explain unique key in sql.

738

How to test for null values?

769

Why left join is used in sql?

705

What is pl sql package?

797

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3313

What is bulk compiling in pl/sql.?

800

What is the difference between instead of trigger and after trigger?

702

how many values can the set function of mysql take? : Sql dba

724

what are rollup and cube in t-sql? : Transact sql

825

What is cte?

742