SELECT SUBSTR(PRODUCTCODE, 1, 2) AS CATEGORY, COUNT(*) AS PRODUCTS FROM PRODUCT GROUP BY SUBSTR(PRODUCTCODE, 1, 2) ORDER BY CATEGORY;
SUBSTR는 ORACLE과 MYSQL 사용이 동일함 SUBSTR(원본값, 시작, 끝)
1 2 3 4 -- 코드를 입력하세요 SELECT SUBSTR(PRODUCT_CODE, 1, 2) AS CATEGORY, COUNT(*) AS PRODUCTS FROM PRODUCT GROUP BY SUBSTR(PRODUCT_CODE, 1, 2) ORDER BY CATEGORY;
1 2 3 4
-- 코드를 입력하세요 SELECT SUBSTR(PRODUCT_CODE, 1, 2) AS CATEGORY, COUNT(*) AS PRODUCTS FROM PRODUCT GROUP BY SUBSTR(PRODUCT_CODE, 1, 2) ORDER BY CATEGORY;