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
15631 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 is set verify off in oracle?

1054

What is a static data dictionary in oracle?

1051

Can we commit inside a function in oracle?

934

How to do paging with oracle?

965

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2346

What is the simplest tool to run commands on oracle servers?

972

How to convert raw data type into text in oracle? Explain

963

How to use group functions in the select clause using oracle?

1041

How to export data to a csv file?

1240

How to loop through a cursor variable?

1035

What are the components of logical database structure in oracle database?

1047

How to see free space of each tablespace?

986

What is a dead lock in oracle?

1065

Explain cascading triggers.

1032

How to drop an existing view in oracle?

914