select order_no,avg(cost) from order group by order

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

Question Posted / yogesh sharma

Answer Posted / yogesh sharma

select order_no,avg(cost) from order group by order_no;

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is an oracle cursor variable?

1047

How much memory your 10g xe server is using?

1087

What are dml statements in oracle?

1075

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2231

What are nested tables?

1150

What is oracle thin client?

1009

What is data block in Oracle?

1089

Explain integrity constraints?

1090

What is BBED in Oracle?

1136

How to define a variable to match a table column data type?

969

What is a nested table and how is it different from a normal table?

1033

What is the difference between $oracle_base and $oracle_home?

1071

What is sharded cluster?

993

Difference between pre-select and pre-query

1081

What is difference between cartesian join and cross join?

1071