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 / aswini
select * from <table_name> where salary in(select max
(salary) from <table_name>);
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Can we commit inside a function in oracle?
What are the differences between blob and clob in oracle?
What is a table index?
what is the scenario where you take the database to NoArchivelog mode?
What is oracle used for?
Is java required for oracle client?
What is an oracle database?
Why does Oracle not permit the use of PCTUSED with indexes?
What to do if the startbd.bat failed to start the xe instance?
What is oracle analytical function?
How to connect the oracle server as sysdba?
What happens if the update subquery returns multiple rows?
What is an oracle user account?
What is an oracle?
What are the numeric comparison operations?