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

Explain how are indexes update?

What is the difference between RBBMS & DBMS?

How do we get field detail of a table?

What is an index associated with a constraint?

what is analyze command ? what kind of statistics does it generate?

What is the purpose of tables, private synonyms and public synonyms in Oracle?

Will you be able to store pictures in the database?explain.

How to use "for" statements in oracle?

What is the parameter mode that can be passed to a procedure?

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2. Display the post code and the total number of purchase orders placed with creditors in that post code.

can we insert any row to dual table if i got the permission from DBA

For more Oracle General Interview Questions Click Here