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

How do I spool in oracle?

1060

Give the different types of rollback segments.

1076

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2143

How do I spool to a csv formatted file using sqlplus?

1083

When do you get a .pll extension in oracle? Explain its importance

1097

How to view the data files in the current database?

1147

How to define an anonymous block?

1243

How to drop an index?

1011

What are transaction isolation levels supported by oracle?

1112

Can group functions be mixed with non-group selection fields?

1070

What is key preserved table?

1077

How to use "for" statements in oracle?

1120

How does oracle handle read consistency?

1151

Is oracle a relational database?

966

How to view all columns in an existing table?

978