2. Display the item number and total cost for each order
line (total cost = no of items X item cost). Name the
calculated column TOTAL COST.
- 2 Answers
- 4981 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / girija.112
ANS:
SELECT ITEM_NO , NO_OF_ITEMS*INDIVIDUAL_ITEM_COST AS "TOTAL COST"
FROM ITEM_TABLE
ITEM_NO TOTAL COST
1001 30000
1002 40000
1003 72000
1004 100000
1006 40000
1007 60000
1008 80000
1009 -
1010 56000
I have assumed that ITEM_NO, NO_OF_ITEMS &
INDIVIDUAL_ITEM_COST columns are in a single table ITEM_TABLE
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ajit
select itemnum,totalcost
from <tab name>
group by cube(itemnum, totalcost);
| Is This Answer Correct ? | 0 Yes | 0 No |
How to call a sub procedure?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
Where is the export dump file located?
How to rename a tablespace in oracle?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
How to rollback the current transaction in oracle?
How many types of segments in Oracle?
Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou
How to concatenate two text values in oracle?
What is a Database instance ? Explain?
Which of the following is not a database object TABLESPACE TABLE INDEX NONE
What are the different types of modules in oracle forms?
Oracle General 
