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 |
what is the uses of cusor
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit
What are the limitations oracle database 10g xe?
State any two functions of oracle?
what is a view?
How do I limit the number of rows returned by an oracle query after ordering?
How to define an explicit cursor in oracle?
17. Display the order number and average item cost for each order.
Can a primary key contain more than one columns?
How to create a stored function in oracle?
What is coalesce function?
How to load data through external tables?