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.
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 |
what is difference between sql plus and sql*plus? (not sql and sql plus).
Explain alias?
What is system tablespace?
I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??
What are triggers in oracle?
What are advantages of dateset in datastage?
How to Identify the previously inserted/updated records in already populated table.
What are the types of trigger in oracle?
What is bulk copy or bcp in oracle?
Q1:code to connect to sql server(database) through jdbc application. Q2:code to connect to Mysql(database) through jdbc application. Q3:code to connect to oracle(database) through jdbc application.
What is a synonym? What are its various types?
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?