Interested to Buy Any Domain ? << Click Here >> for more details...
17. Display the order number and average item cost for each
order.
- 1 Answers
- 3853 Views
- Wipro, I also Faced
- E-Mail Answers
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
Is there a combination of "like" and "in" in sql?
What is Java Pool in Oracle?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is redo log?
How to use "out" parameter properly?
what is a Nested Loop join?
What is the best way to do multi-row insert in oracle?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
Is truncate autocommit in oracle?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is the minimum client footprint required to connect c# to an oracle database?
How to display row numbers with the records?
What is different types of joins?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What are the ways tablespaces can be managed and how do they differ?
