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
- 5029 Views
- Wipro, I also Faced
- E-Mail Answers
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
How do we create privileges in oracle?
How to convert character types to numeric types?
Explain about integrity constraint?
How to unlock the sample user account in oracle?
Please explain compound trigger in oracle?
What are the execution control statements?
What are named parameters?
What is oracle analytical function?
What is meant by joins? List out the types of joins.
What are the advantages of oracle?
What are the differences between blob and clob in oracle?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How to define an external table with a text file?
What do you mean by group by clause?
What is ADDM Advisor in Oracle?
