select a.ename from (select ename from emp ORDER BY SAL desc,ROWNUM DESC)

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

Question Posted / neha

Answer Posted / neha

select a.ename from (select ename from emp ORDER BY SAL
desc,ROWNUM DESC)a
where rownum=1;

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain table?

641

How do I uninstall oracle 11g?

551

What are the execution control statements?

606

How to turn on or off recycle bin for the session?

602

Explain do view contain data?

574

IS it possible to built the oracle database without setting the kernal parameters?

1757

How to lock and unlock a user account in oracle?

607

Why is oracle used?

546

How to call a stored function with parameters?

555

Design database draw er diagram for a certain scenario ?

4095

What do you mean by redo log file mirroring?

549

How to concatenate two text values in oracle?

588

Calculate difference between 2 date / times in oracle sql?

559

What is save point in oracle database?

719

What is the usage of merge statement?

663