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

State the various uses of dbcc command?

1106

Can we connect to ORACLE db using Windows Authentication?

1308

What are the predefined tablespaces in a database?

1141

How to define and use table alias names in oracle?

990

How to assign a table row to a record variable?

1092

What is a Garbage Collection? and what is full recursive Garbage collection?

2956

How to declare a local variable?

1174

What is catalog in Oracle?

1437

What is ordinary table in oracle?

1239

What do you mean by a tablespace?

1090

What is MTTR advisor in Oracle?

1138

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1095

In which language oracle has been developed?

1135

Can select statements be used on views in oracle?

1083

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

1038