24. Display the order number for all orders whose average
item cost is greater than the overall average item cost
across all orders.
Answer Posted / sarath
Small correction to the above answer. Its not MAX, but AVG
Sorry for the mistake
select ORDER_NO,AVG(ITEM_COST) from <TN>
Group by ORDER_NO
having AVG(ITEM_COST) > (Select AVG(AVG(ITEM_COST)) from
<TN> Group by ORDER_NO)
This is to display the Order no whose AVG is > Resultant AVG of All Order's AVG(ITEM _Cost)
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the Tune Query
How to create a single index for multiple columns?
What is dynamic proxy?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
What are the database administrators utilities available?
How to drop a stored function?
How to connect to a remote server?
What is partitioned table in Oracle?
What are the uses of a database trigger?
What is set verify off in oracle?
How to invoke the data pump import utility?
What is a cursor and what are the steps need to be taken?
What is an oracle user account?
How to get a list of all user accounts in the database?
How to do paging with oracle?