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
How are extents allocated to a segment?
How to build data dictionary view an new database?
What are the different pseudo commands? Explain in general?
Please explain oracle data types with examples?
Explain the use of grant option in imp command.
What would you do with an in-doubt distributed transaction?
What is the quickest way to fetch the data from a table?
How to create a new tablespace in oracle?
Oracle
How to invoke the original export import utilities?
What is pragma autonomous transaction in oracle?
Give syntax for SQL and ORACLE joins.
What is oracle sid?
How to assign data of the deleted row to variables?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??