17. Display the order number and average item cost for each order.

17. Display the order number and average item cost for each
order.

Question Posted / deepakgunji

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

More Oracle General Interview Questions

How do I limit the number of oracle database connections generated by weblogic server?

What is Database Buffers ?

What is a subquery?

What are the commands youd issue to show the explain plan for select

How many types of table in Oracle?

How to turn on or off recycle bin for the instance?

Explain the use of indexes option in imp command.

How to recover a dropped index?

What is the difference between sharding and partitioning?

How to convert character types to numeric types?

How to use "in out" parameter properly?

How do we create privileges in oracle?

For more Oracle General Interview Questions Click Here