select * from ( select sal from emp order by sal desc) where rownum <=

5. Display full details for the creditor/s who has received
the single largest payment. Do not use a table join or set
operator anywhere in your query.

Question Posted / ajit

6 Answers
8123 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / ajit

select *
from ( select sal from emp order by sal desc)
where rownum <= 1

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 oracle datasource?

1041

What is a proxy object?

1109

How do I connect to oracle database?

1199

Explain how you would restore a database using RMAN to Point in Time?

2188

What is format trigger?

2121

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4571

What is a directory object?

1137

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2173

How to connect the oracle server as sysdba?

1132

What happens in oracle commit?

1080

Is there an oracle sql query that aggregates multiple rows into one row?

1032

What is the sid in oracle?

1033

How index is implemented in oracle database?

1048

How to define an explicit cursor in oracle?

1102

How to pass parameters to procedures?

1089