Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4766 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 |
26. Display the earliest shipping date in the format: DD/MON/YYYY
What is Oracle table?
What is a named program unit?
Is there an oracle sql query that aggregates multiple rows into one row?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
1.display list of all users from ur data base.what is the query?
What is meant by recursive hints in oracle?
Can a field be used in a report without it appearing in any data group ?
what are the advantages of running a database in NO archive log mode?
candidate key is subset of super key but not vice-verse explain
What is flashback in Oracle?
Explain the difference between sap and oracle?
Oracle General 
