구구단

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

SELECT MAX(DECODE(L1, 2, L1||' * '||L2||' = '||(L1*L2), NULL)) AS "2단",        MAX(DECODE(L1, 3, L1||' * '||L2||' = '||(L1*L2), NULL)) AS "3단",        MAX(DECODE(L1, 4, L1||' * '||L2||' = '||(L1*L2), NULL)) AS "4단",        MAX(DECODE(L1, 5, L1||' * '||L2||' = '||(L1*L2), NULL)) AS "5단",        MAX(DECODE(L1, 6, L1||' * '||L2||' = '||(L1*L2), NULL)) AS "6단",        MAX(DECODE(L1, 7, L1||' * '||L2||' = '||(L1*L2), NULL)) AS "7단",        MAX(DECODE(L1, 8, L1||' * '||L2||' = '||(L1*L2), NULL)) AS "8단",        MAX(DECODE(L1, 9, L1||' * '||L2||' = '||(L1*L2), NULL)) AS "9단"  FROM (SELECT LEVEL AS L1 FROM DUAL CONNECT BY LEVEL < 10) A,       (SELECT LEVEL AS L2 FROM DUAL CONNECT BY LEVEL < 10) B  GROUP BY L2  ORDER BY L2;      2단         3단         4단         5단         6단         7단         8단         9단  ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------  2 * 1 = 2  3 * 1 = 3  4 * 1 = 4  5 * 1 = 5  6 * 1 = 6  7 * 1 = 7  8 * 1 = 8  9 * 1 = 9  2 * 2 = 4  3 * 2 = 6  4 * 2 = 8  5 * 2 = 10 6 * 2 = 12 7 * 2 = 14 8 * 2 = 16 9 * 2 = 18  2 * 3 = 6  3 * 3 = 9  4 * 3 = 12 5 * 3 = 15 6 * 3 = 18 7 * 3 = 21 8 * 3 = 24 9 * 3 = 27  2 * 4 = 8  3 * 4 = 12 4 * 4 = 16 5 * 4 = 20 6 * 4 = 24 7 * 4 = 28 8 * 4 = 32 9 * 4 = 36  2 * 5 = 10 3 * 5 = 15 4 * 5 = 20 5 * 5 = 25 6 * 5 = 30 7 * 5 = 35 8 * 5 = 40 9 * 5 = 45  2 * 6 = 12 3 * 6 = 18 4 * 6 = 24 5 * 6 = 30 6 * 6 = 36 7 * 6 = 42 8 * 6 = 48 9 * 6 = 54  2 * 7 = 14 3 * 7 = 21 4 * 7 = 28 5 * 7 = 35 6 * 7 = 42 7 * 7 = 49 8 * 7 = 56 9 * 7 = 63  2 * 8 = 16 3 * 8 = 24 4 * 8 = 32 5 * 8 = 40 6 * 8 = 48 7 * 8 = 56 8 * 8 = 64 9 * 8 = 72  2 * 9 = 18 3 * 9 = 27 4 * 9 = 36 5 * 9 = 45 6 * 9 = 54 7 * 9 = 63 8 * 9 = 72 9 * 9 = 81

 

 

혹은

 

 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

SELECT MIN (DECODE (A, 2, gugu)) AS "2단"           , MIN (DECODE (A, 3, gugu)) AS "3단"           , MIN (DECODE (A, 4, gugu)) AS "4단"           , MIN (DECODE (A, 5, gugu)) AS "5단"           , MIN (DECODE (A, 6, gugu)) AS "6단"           , MIN (DECODE (A, 7, gugu)) AS "7단"           , MIN (DECODE (A, 8, gugu)) AS "8단"           , MIN (DECODE (A, 9, gugu)) AS "9단"  FROM (SELECT A, B, A || ' * ' || B  || ' = ' ||  A * B AS gugu         FROM (SELECT mod(LEVEL -1 ,9) + 1 AS A, trunc((LEVEL - 1)/9) + 1 AS B                FROM dual CONNECT BY LEVEL <= 81               )        )  GROUP BY B  ORDER BY B;