¡á¿¹ 4_1_9 || UNIONÀÇ Ä®·³À¯Çü
____SELECT '20090101' AS SABUN, 'ÀÌÈ£»ó' AS NAME FROM DUAL
UNION
SELECT '20090102' AS SABUN, 'È«±æµ¿' AS NAME FROM DUAL;
¡á¿¹ 4_1_10 || UNIONÀÇ Ä®·³°³¼ö
SELECT '20090101' AS SABUN, 'ÀÌÈ£»ó' AS NAME, 'LEE HO SANG' AS ENG_NAME FROM DUAL
UNION
SELECT '20090102' AS SABUN, 'È«±æµ¿' AS NAME FROM DUAL;
¡á¿¹ 4_1_11 || UNIONÀÇ »ç¿ë
SELECT '20090101' AS SABUN, 'ÀÌÈ£»ó' AS NAME FROM DUAL
UNION
SELECT '20090102' AS SABUN, 'È«±æµ¿' AS NAME FROM DUAL;
¡á¿¹ 4_1_12 || UNIONÀÇ Æ¯¼º
SELECT '20090101' AS SABUN, 'ÀÌÈ£»ó' AS NAME FROM DUAL
UNION
SELECT '20090102' AS SABUN, 'È«±æµ¿' AS NAME FROM DUAL
UNION
SELECT '20090102' AS SABUN, '±è±æµ¿' AS NAME FROM DUAL
UNION
SELECT '20090102' AS SABUN, 'È«±æµ¿' AS NAME FROM DUAL
UNION
SELECT '20090102' AS SABUN, 'È«±æµ¿' AS NAME FROM DUAL;
¡á¿¹ 4_1_13 || UNION ALLÀÇ Æ¯¼º
SELECT '20090101' AS SABUN, 'ÀÌÈ£»ó' AS NAME FROM DUAL
UNION ALL
SELECT '20090102' AS SABUN, 'È«±æµ¿' AS NAME FROM DUAL
UNION ALL
SELECT '20090102' AS SABUN, '±è±æµ¿' AS NAME FROM DUAL
UNION ALL
SELECT '20090102' AS SABUN, 'È«±æµ¿' AS NAME FROM DUAL
UNION ALL
SELECT '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 INSA
GROUP 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 INSA
GROUP BY JOIN_GBN_CODE
HAVING ROUND(AVG(SALARY)) < 2700;
¡á¿¹ 4_1_16 || ¿¹Á¦ Ç®ÀÌ SQL
SELECT 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 BY
SELECT 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¿Í SORTING
SELECT 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,'ÇÕ°è');