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 happens if the imported table already exists?

what is query and types of query

How to count groups returned with the group by clause in oracle?

What is cluster Key ?

How to sort the query output in oracle?

What is a subquery?

what is difference between foreign key and reference key

What is blob datatype?

How to put more than 1000 values into an oracle in clause?

what's query optimization and without use of IN AND Exist can we get another way data from query

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

What are the attributes of the cursor?

For more Oracle General Interview Questions Click Here