Interested to Buy Any Domain ? << Click Here >> for more details...
24. Display the order number for all orders whose average
item cost is greater than the overall average item cost
across all orders.
- 2 Answers
- 5031 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sarath
select ORDER_NO,AVG(ITEM_COST) from <TN>
Group by ORDER_NO
having AVG(ITEM_COST) > (Select Max(AVG(ITEM_COST)) from
<TN> Group by ORDER_NO)
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
Can I create users through internet explorer in oracle 10g?
What are nested tables?
What are data pump export and import modes?
pls explain connect by prior with example and its real time use
What is a nested table?
What is forall Statement ?
How to restrict the duplicate records in table valuesets
How to pass parameters to procedures?
What are Clusters ?
Give the different types of rollback segments.
What does ROLLBACK do ?
What is catalog in Oracle?
Oracle General 
