select * from (select ename from emp order by rownuum desc) where rownum=

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

Question Posted / pavan

Answer Posted / pavan

select * from (select ename from emp order by rownuum desc)
where rownum=1;

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

1842

Explain compound trigger in oracle?

540

How do I find the database name in oracle?

597

How to pass a parameter to a cursor in oracle?

588

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

602

How do I know if oracle client is installed on windows?

489

What is the usage of control file in oracle?

599

How to call a stored function with parameters?

555

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1441

What is the maximum limit on the number of columns in a table?

545

Explain the use of consistent option in exp command.

544

How to retrieve the count of updated rows?

568

What is SQL Tuning Advisor in Oracle?

625

Will you be able to store pictures in the database?

629

How to use null as conditions in oracle?

572