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
15886 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

How to count groups returned with the group by clause in oracle?

1049

How to define a data field as not null?

1092

What is difference between sid and service name in oracle?

943

How to connect ms access to oracle servers?

980

What is SQL Tuning Advisor in Oracle?

1148

what is the difference between data migration and production migration.

2326

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1882

how do u setup a replication site?

1962

How to create a new table in your schema?

1066

What is a trigger and what are its types?

1198

What is an anonymous block?

1218

What is oracle used for?

1007

What is materialized view in Oracle?

1059

Explain the difference between sql and oracle?

1059

Where do you use decode and case statements?

982