--test data

CREATE TABLE product

(

seq INT PRIMARY KEY AUTO_INCREMENT,

name VARCHAR(10) NOT NULL,

conn VARCHAR(10) NOT NULL,

count INT NOT NULL,

sales_date DATE NOT NULL

);

 

insert into product( name, conn, count, sales_date )

values( 'a', 'z', 1, '2008-08-29' )

, ( 'b', 'z', 2, '2008-09-01' )

, ( 'c', 'x', 5, '2008-09-01' )

, ( 'a', 'x', 4, '2008-09-02' )

, ( 'a', 'y', 3, '2008-09-02' )

, ( 'b', 'y', 4, '2008-09-02' )

, ( 'a', 'x', 7, '2008-01-03' )

;

 

 

--원하시던 select 문

select sales_date, sum( a ) AS a, sum( b ) AS b, sum( c ) AS c

from(

select sales_date

, CASE name when 'a' then tot else 0 end AS a

, CASE name when 'b' then tot else 0 end AS b

, CASE name when 'c' then tot else 0 end AS c

from (

select name, sales_date , sum( count ) AS tot

from product

group by name, sales_date

) AS aa

) AS bb

GROUP by sales_date;

 

첫번째 놈이 해결되면 두번째 건 해결되신다고 하셔서 두번째건 패스

 

 

참고: http://blog.naver.com/uook_/130031508980