로또

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 26 27 28 29 30 31 32

SELECT CHR(64+P) P          , MIN (DECODE (rnum, 1, lottono)) AS N1          , MIN (DECODE (rnum, 2, lottono)) AS N2          , MIN (DECODE (rnum, 3, lottono)) AS N3          , MIN (DECODE (rnum, 4, lottono)) AS N4          , MIN (DECODE (rnum, 5, lottono)) AS N5          , MIN (DECODE (rnum, 6, lottono)) AS N6   FROM (SELECT P, lottono                        , ROW_NUMBER() OVER(PARTITION BY P ORDER BY DBMS_RANDOM.VALUE) rnum                FROM (SELECT LEVEL AS P FROM dual CONNECT BY LEVEL <= 5)                       , (SELECT LEVEL AS lottono FROM dual CONNECT BY LEVEL <= 45))   WHERE rnum <= 7   GROUP BY P   ORDER BY P;      P N1 N2 N3 N4 N5 N6  - -- -- -- -- -- --  A 28  1 36 37 24 17  B 26 19  3 41 45 13  C 34 21 37 24 41 38  D 20 15 39  3 32 25  E 15 36 38 45 10 40      P N1 N2 N3 N4 N5 N6  - -- -- -- -- -- --  A 41 20 33 11 13  7  B  3  9 14 32  2 26  C 37 24 13 12 15 40  D 15 35 12 32 41 40  E 24  3 11 35 42 22