ANS : select max(ename) keep (dense_rank last order by sal) ename from e

How to select the name of employee who is getting maximum
sal with out using subquery

Question Posted / girija.112

Answer Posted / girija.112

ANS :
select max(ename) keep (dense_rank last order by sal) ename
from emp

ENAME
-----
KING

Is This Answer Correct ?

8 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Explain oracle left join with an example?

956

how to do daily transactions with out sql* loader control file regesterd in apps?

1629

How to pass parameters to procedures in oracle?

997

How to create a table index?

1063

What is the difference between view and materialized view in Oracle?

1094

What is the usage of analyze command in oracle?

1033

What is a sub query? What are its various types?

1082

What privilege is needed for a user to delete rows from tables in another schema?

1020

Can multiple columns be used in group by in oracle?

930

How to synchronize 2 schema's objects?

2117

What is a relational database management system?

1064

What is the max number of columns in an oracle table?

932

What are the common oracle dba tasks?

1072

How to write text literals in oracle?

1021

How to drop an index?

910