쿼리 고수님들 도와주세요ㅠㅠ!

Question

감사합니다.!!!!

테스트맨 · Answer

SELECT T1.RANK_NAME, T1.RANK_CD, NVL(T2.COUNT, 0) AS COUNTFROM RANK T1LEFT JOIN (SELECT RANK_NEW_CD AS RANK_CD, COUNT(*) AS COUNTFROM PAY_CALC_1_BP&#64;SEACALWHERE USERID &#61; '00497554'AND SUBSTR(PAY_DATE,1,4) &#61; '2022' GROUP BY RANK_NEW_CD ) T2 ONT1. RANK_CD &#61; T2.RANK_CDWHERE T1.RANK_CD >&#61; 10 AND T1.RANK_CD <&#61; 70 AND T1.RANK_CD NOT BETWEEN 15 AND 19 ORDER BY T1.RANK_CD DESC;

쿼리 고수님들 도와주세요ㅠㅠ!

1개의 답변

기타 목록