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 Single Byte Overhead...?

2556

What is a nvl function? How can it be used?

1032

How many data types are supported?

1080

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3053

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2270

How to rebuild an index in oracle?

1028

Describe the types of sub query?

999

how to clone 9i Database on to 10g Database.

2340

How do I find the database name in oracle?

1039

What is a table index?

1098

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

1085

Explain the use of indexes option in imp command.

1180

What is null value in oracle?

1097

Explain oracle data types with examples?

1030

Please explain oracle data types with examples?

1074