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
What is recovery manager in Oracle?
How many types of table in Oracle?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
Explain oracle’s server parameter file.
What happens to the indexes if a table is recovered?
What is a subquery?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
How to invoke the data pump import utility?
How to define an anonymous block?
Why is oracle so popular?
How to export data with a field delimiter?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
How to get the Installed Oracle Version Information ?
What is a table index in oracle?
State the various uses of dbcc command?