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
- 5242 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 |
How to loop through a cursor variable?
How to drop an index?
How can we find the size of a database?
what is trigger?
What is the string concatenation operator in oracle?
if you ctreate table identity
What WHERE CURRENT OF clause does in a cursor?
What is the data pump export utility?
What is the purpose of a cluster?
I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????
When a form is invoked with call_form, Does oracle forms issues a save point ?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
Oracle General 
