Select * From (Select * From Employee Order By Salary Desc) a Where rownum

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

Question Posted / niladri chatterjee

15 Answers
16089 Views
I also Faced
E-Mail Answers

Select * From (Select * From Employee Order By Salary Desc) a
Where rownum=1 ;

Or

Select * From (Select Emp_id, Emp_NM, Salary From Employee Order By Salary Desc) a
Where rownum=1 ;

Based on Oracle 11g.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What language does oracle use?

1116

What is oracle database 10g express edition?

1127

How to rename an index?

1078

How to create an initialization parameter file?

1060

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2283

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

2018

What is object data modeling?

971

How to define an explicit cursor in oracle?

1048

Why use resource manager in Oracle?

1111

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2363

How do I connect to oracle?

1036

what is normalisation?what are its uses?

2279

What are the different editions of oracle?

1115

What is a user account in oracle?

1130

How do I uninstall oracle client from windows?

1018