Source (line, sudoku_str) as ( select 1, '000680790' from sysibm.sysdummy1 union all select 2, '076009000' from sysibm.sysdummy1 union all select 3, '030002804' from sysibm.sysdummy1 union all select 4, '020000040' from sysibm.sysdummy1 union all select 5, '501000203' from sysibm.sysdummy1 union all select 6, '080000010' from sysibm.sysdummy1 union all select 7, '408300050' from sysibm.sysdummy1 union all select 8, '000800470' from sysibm.sysdummy1 union all select 9, '017045000' from sysibm.sysdummy1 )
Line 1: | 2 | 4 | 5 | 6 | 8 | 3 | 7 | 9 | 1 |
Line 2: | 8 | 7 | 6 | 4 | 1 | 9 | 5 | 3 | 2 |
Line 3: | 1 | 3 | 9 | 5 | 7 | 2 | 8 | 6 | 4 |
Line 4: | 9 | 2 | 3 | 1 | 5 | 8 | 6 | 4 | 7 |
Line 5: | 5 | 6 | 1 | 7 | 9 | 4 | 2 | 8 | 3 |
Line 6: | 7 | 8 | 4 | 2 | 3 | 6 | 9 | 1 | 5 |
Line 7: | 4 | 9 | 8 | 3 | 2 | 7 | 1 | 5 | 6 |
Line 8: | 3 | 5 | 2 | 8 | 6 | 1 | 4 | 7 | 9 |
Line 9: | 6 | 1 | 7 | 9 | 4 | 5 | 3 | 2 | 8 |
Source (line, sudoku_str) as ( select 1, '700020003' from sysibm.sysdummy1 union all select 2, '020467090' from sysibm.sysdummy1 union all select 3, '000000800' from sysibm.sysdummy1 union all select 4, '004000002' from sysibm.sysdummy1 union all select 5, '000090000' from sysibm.sysdummy1 union all select 6, '200003600' from sysibm.sysdummy1 union all select 7, '003000000' from sysibm.sysdummy1 union all select 8, '080719030' from sysibm.sysdummy1 union all select 9, '602030001' from sysibm.sysdummy1 )
Line 1: | 7 | 5 | 1 | 9 | 2 | 8 | 4 | 6 | 3 |
Line 2: | 3 | 2 | 8 | 4 | 6 | 7 | 1 | 9 | 5 |
Line 3: | 9 | 4 | 6 | 3 | 5 | 1 | 8 | 2 | 7 |
Line 4: | 8 | 3 | 4 | 1 | 7 | 6 | 9 | 5 | 2 |
Line 5: | 5 | 6 | 7 | 2 | 9 | 4 | 3 | 1 | 8 |
Line 6: | 2 | 1 | 9 | 5 | 8 | 3 | 6 | 7 | 4 |
Line 7: | 1 | 7 | 3 | 6 | 4 | 2 | 5 | 8 | 9 |
Line 8: | 4 | 8 | 5 | 7 | 1 | 9 | 2 | 3 | 6 |
Line 9: | 6 | 9 | 2 | 8 | 3 | 5 | 7 | 4 | 1 |
Source (line, sudoku_str) as ( select 1, '000000000' from sysibm.sysdummy1 union all select 2, '703100065' from sysibm.sysdummy1 union all select 3, '010689000' from sysibm.sysdummy1 union all select 4, '008002700' from sysibm.sysdummy1 union all select 5, '250000083' from sysibm.sysdummy1 union all select 6, '006400000' from sysibm.sysdummy1 union all select 7, '000346070' from sysibm.sysdummy1 union all select 8, '300000501' from sysibm.sysdummy1 union all select 9, '000000000' from sysibm.sysdummy1 )
Line 1: | 6 | 2 | 9 | 7 | 5 | 3 | 8 | 1 | 4 |
Line 2: | 7 | 8 | 3 | 1 | 2 | 4 | 9 | 6 | 5 |
Line 3: | 4 | 1 | 5 | 6 | 8 | 9 | 3 | 2 | 7 |
Line 4: | 1 | 4 | 8 | 5 | 3 | 2 | 7 | 9 | 6 |
Line 5: | 2 | 5 | 7 | 9 | 6 | 1 | 4 | 8 | 3 |
Line 6: | 9 | 3 | 6 | 4 | 7 | 8 | 1 | 5 | 2 |
Line 7: | 5 | 9 | 1 | 3 | 4 | 6 | 2 | 7 | 8 |
Line 8: | 3 | 6 | 2 | 8 | 9 | 7 | 5 | 4 | 1 |
Line 9: | 8 | 7 | 4 | 2 | 1 | 5 | 6 | 3 | 9 |
Lenny