안드로이드 개발 질문/답변
(글 수 45,052)
도와주세요 ㅠ 답이안나오네요.. 이럴줄 알았으면 학교댕길때 DB수업 열심히 들을껄 그랬나봐요 ㅠ 힘들어요...
2011.05.16 04:22:51
SELECT
name,
COUNT( case when type = 1 then 1 else 0 end ) AS type1,
SUM( case when type = 1 then mon else 0 end ) AS type1mon,
COUNT( case when type = 2 then 1 else 0 end ) AS type2,
SUM( case when type = 2 then mon else 0 end ) AS type2mon,
COUNT( case when type = 3 then 1 else 0 end ) AS type3,
SUM( case when type = 3 then mon else 0 end ) AS type3mon
FROM
table
GROUP BY name
SELECT
name,
SUM( IF( type = 1, 1, 0 ) ) AS type1,
SUM( IF( type = 1, mon, 0 ) ) AS type1mon,
SUM( IF( type = 2, 1, 0 ) ) AS type2,
SUM( IF( type = 2, mon, 0 ) ) AS type2mon,
SUM( IF( type = 3, 1, 0 ) ) AS type3,
SUM( IF( type = 3, mon, 0 ) ) AS type3mon
FROM
table
GROUP BY name