--**************************************
-- Name: Summarizing data type/propertywise with SQL.
-- Description:Summary of records with 'WITH CUBE':
----------------------------------------------------------
We are always faced with situations wherein we have to summarize the data to be presented. Suppose you have item of different types and different colours and you want summary; below is example for same.
Please vote.
-- By: Dinesh Mishra
--
--This code is copyrighted and has-- limited warranties.Please see http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=1413&lngWId=5--for details.--**************************************
Example:
=========
--creating table
create table itemdetails(
item char(6),
colour char(6),
Qty int)
--inserting records
insert into itemdetails values ('CUP','WHITE',2)
insert into itemdetails values ('CUP','YELLOW',5)
insert into itemdetails values ('CUP','BLACK',3)
insert into itemdetails values ('SAUCER','WHITE',2)
insert into itemdetails values ('SAUCER','YELLOW',5)
insert into itemdetails values ('SAUCER','BLACK',3)
--using with cube
SELECT ITEM,COLOUR,SUM(QTY)
FROM ITEMDETAILS
GROUP BY ITEM,COLOUR WITH CUBE
|
