We have created a awesome theme
Far far away,behind the word mountains, far from the countries

INFO ½ÇÀü DB¸ðµ¨¸µ°ú SQL°úÁ¤

INFO

½ÇÀü DB¸ðµ¨¸µ°ú SQL°úÁ¤
Á¶È¸¼ö 7009
Á¦¸ñ Chapter1_Á¶ÀÎÀÇ ¿ø¸® : ¿¹Á¦¸ðÀ½4
ÀÛ¼ºÀÚ °ü¸®ÀÚ
ÀÛ¼ºÀÏÀÚ 2021-12-02

¡á¿¹ 1_2_18  ||  ¿¡·¯¹ß»ý ¿¹Á¦_1
SELECT  T1.SABUN, T1.NAME, T1.AGE, T1.PHONE,
          T2.SABUN, T2.ACAD_ABILITY, T2.MAJOR_STUDY, T2.GRAT_YM,
          T3.ACAD_ABILITY
FROM   TABLE_1 T1, TABLE_2 T2, TABLE_3 T3
WHERE  T1.SABUN = T2.SABUN(+)
   AND  T2.ACAD_ABILITY(+) = '´ëÁ¹'
   AND  T2.ACAD_ABILITY(+) = T3.ACAD_ABILITY(+);



¡á¿¹ 1_2_19  ||  ¿¡·¯¹ß»ý ¿¹Á¦_2
SELECT  T1.SABUN, T1.NAME, T1.AGE, T1.PHONE,
          T2.SABUN, T2.ACAD_ABILITY, T2.MAJOR_STUDY, T2.GRAT_YM,
          T3.ACAD_ABILITY
FROM   TABLE_1 T1, TABLE_2 T2, TABLE_3 T3
WHERE  T1.SABUN = T2.SABUN(+)
   AND  T2.ACAD_ABILITY(+) = '´ëÁ¹'
   AND  T2.ACAD_ABILITY(+) = T3.ACAD_ABILITY;



¡á¿¹ 1_2_20  || OUT JOINÀÇ ¿Ã¹Ù¸¥ ¿¹ 1
SELECT  TT2.SABUN, TT2.ACAD_ABILITY, TT2.MAJOR_STUDY, TT2.GRAT_YM,
          TT3 .GRADE_NUM,
          DECODE(TT3.GRADE_NUM, NULL, 100, TT3.GRADE_NUM) AS T_GRADE_NUM
FROM TABLE_2 TT2, TABLE_3 TT3
WHERE TT2.ACAD_ABILITY = TT3.ACAD_ABILITY(+);



¡á¿¹ 1_2_21  ||  OUT JOINÀÇ ¿Ã¹Ù¸¥ ¿¹ 2
SELECT  T1.SABUN, T1.NAME, T1.AGE, T1.PHONE,
          T2.SABUN, T2.ACAD_ABILITY, T2.MAJOR_STUDY, T2.GRAT_YM,
          T2.ACAD_ABILITY, T2.GRADE_NUM, T2.T_GRADE_NUM
FROM  TABLE_1 T1,
         (
           SELECT  TT2.SABUN, TT2.ACAD_ABILITY, TT2.MAJOR_STUDY,
                     TT2.GRAT_YM, TT3.GRADE_NUM,
                     DECODE(TT3.GRADE_NUM,NULL,100,TT3.GRADE_NUM) AS T_GRADE_NUM
           FROM TABLE_2 TT2, TABLE_3 TT3
           WHERE TT2.ACAD_ABILITY = TT3.ACAD_ABILITY(+)
         ) T2
WHERE  T1.SABUN = T2.SABUN(+);

÷ºÎÆÄÀÏ