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 recovery manager in Oracle?

994

How to create a table index in oracle?

1086

How to define an external table with a text file?

1021

What is oracle thin client?

975

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1047

What is object data modeling?

907

What is oracle data type?

903

Explain a private synonyms?

983

What are the different types of modules in oracle forms?

952

How to get execution statistics reports on query statements?

1009

How to specify default values in insert statement using oracle?

1038

How to display row numbers with the records?

1025

How to retrieve data from an explicit cursor?

1009

Can group functions be used in the order by clause in oracle?

940

What is a oracle database?

996