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

15 Answers
15453 Views
I also Faced
E-Mail Answers

Answer Posted / pavan

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

Is This Answer Correct ?

0 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain an index segment?

1043

How do I connect to oracle database?

1028

What are the different pseudo commands? Explain in general?

1022

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2153

How to do paging with oracle?

950

How to view the tablespaces in the current database?

929

How do I reset a sequence in oracle?

1052

defination of bitmap index

2047

How view is different from a table?

969

What are the oracle differences between nvl and coalesce

1068

Is oracle an operator?

885

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1696

Explain the use of full option in exp command.

1057

How to drop an existing view in oracle?

905

How to export several tables together?

990