17. Display the order number and average item cost for each
order.

Answer Posted / yogesh sharma

select order_no,avg(cost) from order group by order_no;

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How different is ms access and oracle?

648


What is logical backup in oracle?

644


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

1908


List out the components of logical database structure of oracle database.

663


How to convert characters to dates in oracle?

639






Can a formula column referred to columns in higher group ?

2167


how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

1666


What is oracle in java?

624


How to manage transaction isolation level?

649


How many anonymous blocks can be defined?

687


What is the use of file param in imp command?

724


What are internal user account in oracle?

646


What happens if you use a wrong connect identifier?

597


How translate command is different from replace?

633


How do we get field details of a table?

624