|
|
-
Guenter Initial Review 2 Months ago through Puzzles
This challenge is a puzzle of numbers. Everyone of you might have came across this puzzle named 'Sudoku'. I usually see it in the daily Newspaper.
The puzzle is just a play of numbers from 1 to 9, arranging them in nine boxes in an order such that each nu
|
|
|
-
OldStd Commented 11 Months ago through Puzzles
I copied the codes of this solution from the clipboard and tried half a dozen of puzzles with the solution. Unfortunately none of the puzzles were solved.
I inserted some simple select statements into the solutions at various points and found that
tab
|
-
Guenter Initial Review 11 Months ago through Puzzles
The solution is re-submitted to address a comment by the moderator who rejected the original solution because it referenced a column “Id” not found in the Table TC63.
In this solution I am making use of the following ideas (or strategies):
1. Look fo
|
-
OldStd Solved 11 Months ago through Puzzles
The solution is re-submitted to address a comment by the moderator who rejected the original solution because it referenced a column “Id” not found in the Table TC63.
In this solution I am making use of the following ideas (or strategies):
1. Look fo
|
-
OldStd Commented 11 Months ago through Puzzles
The solution is re-submitted to address a comment by the moderator who rejected the original solution because it referenced a column “Id” not found in the Table TC63.
In this solution I am making use of the following ideas (or strategies):
1. Look fo
|
-
Guenter Initial Review 11 Months ago through Puzzles
In this solution I am making use of the following ideas (or strategies):
1. Look for unique values in the individual cells - (Cells_Strategy)
2. Look for unique values in each row – (Rows_Strategy)
3. Look for unique values in each column -- (Cols_Str
|
-
OldStd Commented 11 Months ago through Puzzles
Please delete puzzle g=26 from the table Entries because it contains a lot of entry errors:
select '
/* display of initial data
g R/C C1 C2 C3 C4 C5 C6 C7 C8 C9
|
-
OldStd Commented 12 Months ago through Puzzles
Please delete puzzle g=26 from the table Entries because it contains many entry errors.
select '
/* display of initial data
g R/C C1 C2 C3 C4 C5 C6 C7 C8 C9
26 R1 7 0 4 0 9 0 3 0 1
26 R2 0 8 0 1 0 4 6 0 6
26 R3 0 9 4 0 2 0 5 0 3
26 R4 0 1 0 1
|
-
OldStd Commented 12 Months ago through Puzzles
Please delete puzzle 26 from the table Entries because there were lot of entry errors.
--select '
Select g,r,v, COUNT(*) as q from Entries
where v>0
group by g, r,v having count(*)>=2
/* results
g r v q
26 2 6 2
26 4 1 2
26 5 2 2
26 6 6
|