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 / rajeev kumar
select max(salary) from <TN> where salary not in(select max
(salary) from <TN>)
salary->field name
Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
How to load excel data sheet to oracle database
What are the different pseudo commands? Explain in general?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
Explain the use of grant option in exp command.
What is object data modeling?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What is the usage of save points in oracle database?
What is translate in oracle?
Can we save images in a database and if yes, how?
What are the attributes that are found in a cursor?
What is not equal to in oracle?
How to store only time; not date and time?
How to initialize variables with default values?
How to put more than 1000 values into an oracle in clause?
What are the types of trigger in oracle?