다양한 데이터 추출방법

/*
    직급 코드가 G1(대리) 인 직원
*/

SELECT EMPNO
            ,JUMIN_NO
            ,EMP_NAME
            ,BIRTH_DATE
            ,JIKGB_CODE
FROM LKDM_A01
WHERE JIKGB_CODE IN ('G1');

/*
    직급 코드가 G1(대리) 인 직원
*/

SELECT EMPNO
            ,JUMIN_NO
            ,EMP_NAME
            ,BIRTH_DATE
            ,JIKGB_CODE
FROM LKDM_A01
WHERE JIKGB_CODE = 'G1'

 

/*
 직급 코드가 G1(대리) 인 직원
*/SELECT EMPNO
            ,JUMIN_NO
            ,EMP_NAME
            ,BIRTH_DATE
            ,JIKGB_CODE
FROM LKDM_A01
WHERE JIKGB_CODE IN (SELECT JIKGB_CODE
                                      FROM LKDM_A92
                                      WHERE JIKGB_NAME='대 리')

 

/*
    직급코드가 G1 인 직원
*/SELECT EMPNO
            ,JUMIN_NO
            ,EMP_NAME
            ,BIRTH_DATE
            ,JIKGB_CODE
FROM LKDM_A01
WHERE EXISTS    (SELECT JIKGB_CODE
                         FROM LKDM_A92
                         WHERE JIKGB_CODE = LKDM_A01.JIKGB_CODE
                         AND JIKGB_CODE='G1')