Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Solving Sudoku with SQL (2010)

developerfusion.com

Post reply on HN
Print view View original

1–5 of 5 posts

Re: Solving Sudoku with SQL (2010)

#3

Post by polsoul »

thorin wrote: post #2

This is the article I remeber. It's a bit older too. I prefer the prolog solution! https://technology.amis.nl/2009/10/13/oracle-rdbms-11gr2-sol...

The great thing about it is that it's just one SQL statement.

One SQL statement with recursion ughhh, arghhhh ... a bit older but still quite complicated to me - I've spent many hours on it and still cannot fully understand how it works(this recursion thingy with all the university variables memories - i,k,j , do you remember them :)). Definitely a good brain teaser, good luck.

Re: Solving Sudoku with SQL (2010)

#4

Post by polsoul »

polsoul wrote: post #3
thorin wrote: post #2

This is the article I remeber. It's a bit older too. I prefer the prolog solution! https://technology.amis.nl/2009/10/13/oracle-rdbms-11gr2-sol...

The great thing about it is that it's just one SQL statement. One SQL statement with recursion ughhh, arghhhh ... a bit older but still quite complicated to me - I've spent many hours on it and still cannot fully understand how it works(this recursion thingy with all the university variables memories - i,k,j , do you remember them :)). Definitely a good brain teaser, good luck.

Pretty easy to test it using:

http://sqlfiddle.com/ (just select Oracle 11g R2 instead of MySQL from the drop down -> press Build Schema -> paste the SQL statment into the right window -> Run SQL )

Post reply on HN