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

How oracle handles dead locks?

1038

How to return top 5 rows in oracle?

1017

What is set verify off in oracle?

1057

How to run queries on external tables?

1003

various types of hints and their usage

2645

How to rename an index in oracle?

1083

What is a trigger and what are its types in oracle?

1028

How to use null as conditions in oracle?

1032

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2008

What is Virtual Private Database in Oracle?

1038

What is meant by raw datatype?

1026

Briefly explain what is literal? Give an example where it can be used?

997

What are the general rules on data consistency?

978

What is where clause in oracle?

1000

What is partitioned table in Oracle?

1136