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
How different is ms access and oracle?
What is logical backup in oracle?
how to clone 9i Database on to 10g Database.
List out the components of logical database structure of oracle database.
How to convert characters to dates in oracle?
Can a formula column referred to columns in higher group ?
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....
What is oracle in java?
How to manage transaction isolation level?
How many anonymous blocks can be defined?
What is the use of file param in imp command?
What are internal user account in oracle?
What happens if you use a wrong connect identifier?
How translate command is different from replace?
How do we get field details of a table?