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
- 5115 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 many categories of data types in oracle?
How to create a stored function in oracle?
How do I manually create a database in oracle?
How will you identify oracle database software release?
What is sequence?
Explain mutating triggers.
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
How index is implemented in oracle database?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
How to bring a tablespace online?
Explain the difference between a procedure and a function?
How to use subqueries with the in operator using oracle?
How to use regular expression in pattern match conditions in oracle?
What is materialized view in Oracle?
