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 |
How to enter a new row into a table interactively?
How do we get field details of a table?
How to rename a column in an existing table?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
How to create index-by table in oracle?
What is different types of joins?
What is a table index in oracle?
What is bulk copy or bcp in oracle?
What is the minimum client footprint required to connect c# to an oracle database?
How does the on-delete-cascade statement work?
How to create a table in a specific tablespace?
can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?