17. Display the order number and average item cost for each
order.
- 1 Answers
- 3430 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 |
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
What are the differences between char and varchar2 in oracle?
What are the attributes of cursor?
Difference between sub query and nested query ?
19 Answers Keane India Ltd, TCS,
How to import one table back from a dump file?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
How to use subqueries in the from clause in oracle?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
Is it possible to disable the parameter from while running the report ?
How to select all columns of all rows from a table in oracle?
How to find out what privileges a user currently has in oracle?
What is different bet native dynamic sql and Dbms_Sql?
Oracle General 
