Hi,
I am using oracle 11g version.
I have a reporting requirement where in I have to produce a cross tab as explained below. Please help me in writing an SQL query to achieve this. Many thanks.
Sample data:
------------------
Customer product type
--------------------------------------------
AAA DVD
AAA Tape
BBB Tape
CCC DVD
CCC Bluray
DDD DVD
DDD Tape
DDD Bluray
Logic
AAA BBB CCC DDD
DVD Tape Bluray DVD Tape Bluray DVD Tape Bluray DVD Tape Bluray
DVD 1 DVD DVD 1 DVD 1
Tape 1 Tape 1 Tape Tape 1 1
Bluray Bluray Bluray 1 Bluray 1
Final Output
No. of customers who purchased the products across all product types
DVD Tape Bluray
DVD 2 1
Tape 2 1 1
Bluray 1 1
Scripts:
-------------------------
create table cust_product(customer varchar2(5), product_type varchar2(10));
insert into cust_product values('AAA','DVD');
insert into cust_product values('AAA','Tape');
insert into cust_product values('BBB','Tape');
insert into cust_product values('CCC','DVD');
insert into cust_product values('CCC','Bluray');
insert into cust_product values('DDD','DVD');
insert into cust_product values('DDD','Tape');
insert into cust_product values('DDD','Bluray');