select 상품, sum(cnt) AS 접수건수
from (
SELECT
case WHEN Ca_Code LIKE 'N%'
THEN '명함'
WHEN Ca_Code LIKE 'S%'
THEN '스티커'
WHEN Ca_Code LIKE 'B%'
THEN '전단'
WHEN Ca_Code LIKE 'E%'
THEN '봉투'
WHEN Ca_Code LIKE 'C%'
THEN '상업인쇄'
WHEN Ca_Code LIKE 'V%'
THEN '그린백'
WHEN Ca_Code LIKE 'M%'
THEN '경인쇄'
WHEN Ca_Code LIKE 'O%'
THEN '기타인쇄'
ELSE NULL
END AS 상품 ,
COUNT(*) AS cnt
FROM GoodPrinting..WEB_OrderPInfo
WHERE OPI_Date BETWEEN '20170320' AND '20170324'
GROUP BY Ca_Code
) AS A
GROUP BY 상품
조금전에 질문해서 결과가 제대로 나왔습니다.
여기서 또 질문할게요!

AUTO접수건은 pdfauto..TbDPAutoList 라는 테이블에서 가져와야하는데요
여기서 어떤식으로 해야 될까요??
부탁드립니다..!!!!
총접수건수중에 AUTO접수건을가져와야합니다. 다른테이블에서요....
Comment 2
-
사야카
2017.03.29 15:34
필드명을 모르니...select 상품, sum(cnt) AS 접수건수,(select CASE GROUP BY 적절히 사용하시면 될거같습니다... from pdfauto..TbDPAutoList ) AS AUTO접수건from (SELECTcase WHEN Ca_Code LIKE 'N%'THEN '명함'WHEN Ca_Code LIKE 'S%'THEN '스티커'WHEN Ca_Code LIKE 'B%'THEN '전단'WHEN Ca_Code LIKE 'E%'THEN '봉투'WHEN Ca_Code LIKE 'C%'THEN '상업인쇄'WHEN Ca_Code LIKE 'V%'THEN '그린백'WHEN Ca_Code LIKE 'M%'THEN '경인쇄'WHEN Ca_Code LIKE 'O%'THEN '기타인쇄'ELSE NULLEND AS 상품 ,COUNT(*) AS cntFROM GoodPrinting..WEB_OrderPInfoWHERE OPI_Date BETWEEN '20170320' AND '20170324'GROUP BY Ca_Code) AS AGROUP BY 상품 -
파란약
2017.03.29 15:38
아! 저렇게 한번! 해보겠습니다~!! 감사합니다!