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

Differentiate between % rowtype and type record.

1197

What is the difference between a subquery and a join?

1014

What are the two different parts of the pl/sql packages?

1026

what is data control language? : Sql dba

959

Can primary key be changed?

871

Is trigger a stored procedure?

887

What is compiled query?

956

What is string data type in sql?

1055

How to take user input in pl sql?

1107

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1099

What is a recursive join sql?

1027

What is the starting oracle error number? What is meant by forward declaration in functions?

940

Is time a data type in sql?

854

Explain the rollback statement?

964

What do you mean by rowid?

917