Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 6 Answers
- 7909 Views
- Wipro, I also Faced
- E-Mail Answers
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 are named parameters?
How to join two tables in a single query using oracle?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
What is SQL access advisor in Oracle?
How to retrieve values from data fields in record variables?
What is a package ? What are the advantages of package ?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
How to apply filtering criteria at group level in oracle?
Explain the use of constraints option in exp command.
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
List out the difference between commit, rollback, and savepoint?
What is ADDM Advisor in Oracle?
What is oracle host variable?
Explain what are the advantages of views?
what is the use of system.effective.date variable in oracle?
