신입으로 너무 힘드네요 오라클쓰다 ms sql쓰는데 ㅠㅠ
SELECT TOP 100 PERCENT
A.COUNTRY_NAME COL2,
A.GUBUN COL1, A.CNT, A.COUNTRY_CODE, A.RIGHT_DIV
FROM
(
SELECT DBO.FN_COUNTRY_NAME(COUNTRY_CODE) COUNTRY_NAME
,DBO.FN_COM_CODE_NAME('RIGHT_DIV', RIGHT_DIV, 'ko-kr', 'ko-kr')+'출원' GUBUN, COUNT(*) CNT, COUNTRY_CODE, RIGHT_DIV
FROM TB_APP_MST
WHERE DBO.FN_ISNULL(APP_NO, NULL) IS NOT NULL
AND DBO.FN_ISNULL(REG_NO, NULL) IS NULL
AND ABD_YN <> '1'
AND RIGHT_DIV <> '40'
GROUP BY COUNTRY_CODE, RIGHT_DIV
UNION ALL
SELECT DBO.FN_COUNTRY_NAME(COUNTRY_CODE) COUNTRY_NAME
,DBO.FN_COM_CODE_NAME('RIGHT_DIV', RIGHT_DIV, 'ko-kr', 'ko-kr')+'등록' GUBUN, COUNT(*) CNT, COUNTRY_CODE, RIGHT_DIV
FROM TB_APP_MST
WHERE DBO.FN_ISNULL(REG_NO, NULL) IS NOT NULL
AND ABD_YN <> '1'
AND RIGHT_DIV <> '40'
GROUP BY COUNTRY_CODE, RIGHT_DIV
) A
ORDER BY A.COUNTRY_NAME
이쿼린데 기간 조건을 주고 싶어서 사이에 {#main}을 넣어서
SELECT TOP 100 PERCENT
A.COUNTRY_NAME COL2,
A.GUBUN COL1, A.CNT, A.COUNTRY_CODE, A.RIGHT_DIV
FROM
(
SELECT DBO.FN_COUNTRY_NAME(COUNTRY_CODE) COUNTRY_NAME
,DBO.FN_COM_CODE_NAME('RIGHT_DIV', RIGHT_DIV, 'ko-kr', 'ko-kr')+'출원' GUBUN, COUNT(*) CNT, COUNTRY_CODE, RIGHT_DIV
FROM TB_APP_MST
WHERE DBO.FN_ISNULL(APP_NO, NULL) IS NOT NULL
AND DBO.FN_ISNULL(REG_NO, NULL) IS NULL
AND ABD_YN <> '1'
AND RIGHT_DIV <> '40'
AND APP_DATE >= '20110523'
AND APP_DATE <= '20110523'
GROUP BY COUNTRY_CODE, RIGHT_DIV
UNION ALL
SELECT DBO.FN_COUNTRY_NAME(COUNTRY_CODE) COUNTRY_NAME
,DBO.FN_COM_CODE_NAME('RIGHT_DIV', RIGHT_DIV, 'ko-kr', 'ko-kr')+'등록' GUBUN, COUNT(*) CNT, COUNTRY_CODE, RIGHT_DIV
FROM TB_APP_MST
WHERE DBO.FN_ISNULL(REG_NO, NULL) IS NOT NULL
AND ABD_YN <> '1'
AND RIGHT_DIV <> '40'
AND APP_DATE >= '20110523'
AND APP_DATE <= '20110523'
GROUP BY COUNTRY_CODE, RIGHT_DIV
) A
ORDER BY A.COUNTRY_NAME
이렇게 했는데 결과가 뜨질 않네요 ㅠㅠ
에효 ms sql어려워요 ㅠㅠ |