Any recommended websites for SQL puzzles?

Question

Is there any website that contains SQL puzzles, tips/tricks etc?

Any version of SQL (Oracle, MSSQL etc) will do. Just want to solve some general SQL puzzles and want to learn more about SQL.

Thanks in advance!

Answer 1

There are some SQL puzzles on Lionel Clarke's blog.

There are a few others on "Puzzled by T-SQL" blog by Itzik Ben-Gan on the SQL Server Magazine website.

More quiz-style questions than puzzles on http://www.sqlquiz.com/.

Answer 2

I'd recommend having at a look at Joe Celko for puzzles. Any articles by him on the net and his books on SQL are also well worth reading.

Answer 3

SQL Server Central have a "Question of the Day" series on their site.

http://www.sqlservercentral.com/Questions

There is also some generic content related to various T-SQL puzzles on the site here:

http://www.sqlservercentral.com/tags/T-SQL/SQL+Puzzles/

Answer 4

Try the tutorials at sqlzoo.net

Answer 5

I love this! Here are some ideas:

http://www.johnsenner.com/blog/2007/10/eight-queens-in-sql.html

http://www.johnsenner.com/blog/2009/04/one-tough-puzzle.html

The 'Who lives in a red house?' style of logic problems are particularly cool - why not try this one?

The Zebra Puzzle

Answer 6

Less Than Dot Programmer Puzzles

Most of these puzzles can be solved using tsql.