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

How to define a variable to match a table column data type?

993

What are the limitations of check constraint?

1034

How many categories of data types in oracle?

1032

What suggestions do you have to reduce the network traffic?

967

What is program global area (pga) in oracle?

1034

How to establish administrator authentication to the server?

1045

Can we store images in oracle database?

1013

How to drop a stored procedure in oracle?

1056

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1070

How to login to the server without an instance?

1167

How to pass parameters to procedures in oracle?

1043

Will you be able to store pictures in the database?

1126

How to create a new oracle data file?

1035

Describe an oracle table?

1056

What is max rowid in oracle?

1026