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 are the oracle DML commands possible through an update strategy?

579


Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

1579


Explain cascading triggers.

572


How to generate query output in html format?

563


How to display row numbers with the records?

584






What is an oracle?

575


what's query optimization and without use of IN AND Exist can we get another way data from query

1662


How many types of cluster table in Oracle?

573


How to delete a column in an existing table?

590


What is the difference between online and offline backups?

560


How to use regular expression in pattern match conditions in oracle?

573


Does oracle charge for java?

586


What is where clause in oracle?

526


What is BBED in Oracle?

683


if you ctreate table identity

1843