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.

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 do you mean by merge in oracle?

593


How to use in conditions in oracle?

557


How to pass a cursor variable to a procedure?

562


what is dynamic SGA and static SGA

3840


Explain enable novalidate constraint.

597






How to end the current transaction in oracle?

559


What do you understand by a database object?

588


How to use "for" statements in oracle?

592


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

1858


What is query image?

584


What is a static data dictionary in oracle?

569


what is insert all statement in sql

5518


How to create a stored program unit?

581


What is the difference between post-database commit and post-form commit?

515


WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

1705