select a.ename from (select ename from emp ORDER BY SAL desc,ROWNUM DESC)

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

Question Posted / neha

Answer Posted / neha

select a.ename from (select ename from emp ORDER BY SAL
desc,ROWNUM DESC)a
where rownum=1;

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What privilege is needed for a user to insert rows to tables in another schema?

957

Differentiate between function and procedure in oracle.

1022

What are the oracle differences between nvl and coalesce

1069

How to estimate disk space needed for an export job?

992

How do you store pictures in a database?

952

When do we use group by clause in a sql query?

995

What is an oracle cursor variable?

1009

What do you mean by group by clause?

978

Explain how are indexes update?

1016

How to create a new view in oracle?

1016

How to view all columns in an existing table?

876

What are the execution control statements in oracle?

1028

What is open database communication (odbc) in oracle?

949

How to import one table back from a dump file?

972

How to execute the package in oracle?

1039