Interested to Buy Any Domain ? << Click Here >> for more details...
24. Display the order number for all orders whose average
item cost is greater than the overall average item cost
across all orders.
- 2 Answers
- 5033 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / sarath
select ORDER_NO,AVG(ITEM_COST) from <TN>
Group by ORDER_NO
having AVG(ITEM_COST) > (Select Max(AVG(ITEM_COST)) from
<TN> Group by ORDER_NO)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How many types of table in Oracle?
what is insert all statement in sql
Is primary key indexed by default in oracle?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
How to write a query with a right outer join in oracle?
How to load data from external tables to regular tables?
types of indexes and the rationale behind choosing a particular index for a situation.
How to assign values to data fields in record variables?
What are dml statements in oracle?
Explain what are the type of synonyms?
What is an oracle recycle bin?
What is a sub query? Describe its types?
What are the differences between blob and clob in oracle?
Differentiate between function and procedure in oracle.
How to view the data files in the current database?
