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

What are the different types of synonyms?

What is difference between sid and service name in oracle?

What are the data types in oracle?

various types of joins

How to define a data field as not null?

what is the syntax of INSERT command?

What happens if the update subquery returns multiple rows?

difference between oracle8i and oracle9i

What is the Extension of Oracle Database? As extension of Access Database is .mdb

How to drop a tablespace?

How you open and close a cursor variable.Why it is required?

How to install oracle database 10g xe?

For more Oracle General Interview Questions Click Here