17. Display the order number and average item cost for each
order.
- 1 Answers
- 3563 Views
- Wipro, I also Faced
- E-Mail Answers
Answer / yogesh sharma
select order_no,avg(cost) from order group by order_no;
| Is This Answer Correct ? | 4 Yes | 1 No |
What is oracle analytical function?
Explain the use of record option in exp command.
What is the difference between I and G in Oracle?
How to retrieve data from an explicit cursor?
What do you mean by merge in oracle and how can we merge two tables?
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance
What are the different type of Segments ?
What is using clause and give example?
Anyone have the Latest Oracle Dumbs?While u have please forard to narain1411@gmail.com
Can multiple cursors being opened at the same time?
What is tns service name?
In Oracle 10g, "g" Stands for what?
Oracle General 
