17. Display the order number and average item cost for each
order.
Answer / yogesh sharma
select order_no,avg(cost) from order group by order_no;
Is This Answer Correct ? | 4 Yes | 1 No |
What is currency type in database ?
What are the set operators union, union all, minus & intersect meant to do?
What is an oracle cursor variable?
how many outer joins are used in a single sql query? is there any limitations for using of outer joins?
2 Answers BOB Technologies, Cap Gemini, IBM,
Explain an exception and its types?
Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?
Explain the different normalization forms?
What is oracle update statement with inner join ?
Difference between an implicit & an explicit cursor.?
What is a select query statement in oracle?
what is the syntax of CREATE command?
What are the roles of dba?