We have created a awesome themeFar far away,behind the word mountains, far from the countries
INFO ½ÇÀü DB¸ðµ¨¸µ°ú SQL°úÁ¤
¡á¿¹ 4_1_9 || UNIONÀÇ Ä®·³À¯Çü____SELECT '20090101' AS SABUN, 'ÀÌÈ£»ó' AS NAME FROM DUALUNIONSELECT '20090102' AS SABUN, 'È«±æµ¿' AS NAME FROM DUAL;
¡á¿¹ 4_1_10 || UNIONÀÇ Ä®·³°³¼öSELECT '20090101' AS SABUN, 'ÀÌÈ£»ó' AS NAME, 'LEE HO SANG' AS ENG_NAME FROM DUALUNIONSELECT '20090102' AS SABUN, 'È«±æµ¿' AS NAME FROM DUAL;
¡á¿¹ 4_1_11 || UNIONÀÇ »ç¿ëSELECT '20090101' AS SABUN, 'ÀÌÈ£»ó' AS NAME FROM DUALUNIONSELECT '20090102' AS SABUN, 'È«±æµ¿' AS NAME FROM DUAL;
¡á¿¹ 4_1_12 || UNIONÀÇ Æ¯¼ºSELECT '20090101' AS SABUN, 'ÀÌÈ£»ó' AS NAME FROM DUALUNIONSELECT '20090102' AS SABUN, 'È«±æµ¿' AS NAME FROM DUALUNIONSELECT '20090102' AS SABUN, '±è±æµ¿' AS NAME FROM DUALUNIONSELECT '20090102' AS SABUN, 'È«±æµ¿' AS NAME FROM DUALUNIONSELECT '20090102' AS SABUN, 'È«±æµ¿' AS NAME FROM DUAL;
¡á¿¹ 4_1_13 || UNION ALLÀÇ Æ¯¼ºSELECT '20090101' AS SABUN, 'ÀÌÈ£»ó' AS NAME FROM DUALUNION ALLSELECT '20090102' AS SABUN, 'È«±æµ¿' AS NAME FROM DUALUNION ALLSELECT '20090102' AS SABUN, '±è±æµ¿' AS NAME FROM DUALUNION ALLSELECT '20090102' AS SABUN, 'È«±æµ¿' AS NAME FROM DUALUNION ALLSELECT '20090102' AS SABUN, 'È«±æµ¿' AS NAME FROM DUAL;
¡á¿¹ 4_1_14 || GROUP BY ÀÇ »ç¿ëSELECT JOIN_GBN_CODE, COUNT(SABUN), MAX(NAME), MIN(ENG_NAME),COUNT(ENG_NAME), ROUND(AVG(SALARY)) FROM INSAGROUP BY JOIN_GBN_CODE;
¡á¿¹ 4_1_15 || GROUP BY ¿Í HAVINGÀý »ç¿ëSELECT JOIN_GBN_CODE, COUNT(SABUN), MAX(NAME), MIN(ENG_NAME), COUNT(ENG_NAME), ROUND(AVG(SALARY)) FROM INSAGROUP BY JOIN_GBN_CODEHAVING ROUND(AVG(SALARY)) < 2700;
¡á¿¹ 4_1_16 || ¿¹Á¦ Ç®ÀÌ SQLSELECT NO, JOIN_GBN_CODE, COUNT(SABUN), MAX(NAME), MIN(ENG_NAME), COUNT(ENG_NAME), ROUND(AVG(SALARY)) FROM INSA, (SELECT 1 AS NO FROM DUAL UNION SELECT 2 AS NO FROM DUAL)GROUP BY NO, JOIN_GBN_CODE;
¡á¿¹ 4_1_17 || GROUP BY¿Í ORDER BYSELECT DECODE(NO,1,JOIN_GBN_CODE,'ÇÕ°è'), COUNT(SABUN), MAX(NAME), MIN(ENG_NAME), COUNT(ENG_NAME), ROUND(AVG(SALARY)) FROM INSA, (SELECT 1 AS NO FROM DUAL UNION SELECT 2 AS NO FROM DUAL)GROUP BY DECODE(NO,1,JOIN_GBN_CODE,'ÇÕ°è')ORDER BY DECODE(NO,1,JOIN_GBN_CODE,'ÇÕ°è');
¡á¿¹ 4_1_18 || GROUP BY¿Í SORTINGSELECT DECODE(NO,1,JOIN_GBN_CODE,'ÇÕ°è'), COUNT(SABUN), MAX(NAME), MIN(ENG_NAME), COUNT(ENG_NAME), ROUND(AVG(SALARY)) FROM INSA, (SELECT 1 AS NO FROM DUAL UNION SELECT 2 AS NO FROM____ DUAL)GROUP BY DECODE(NO,1,JOIN_GBN_CODE,'ÇÕ°è');