SQL 谜题与答案
SQL puzzles & answers
Joe Celko · 初版 1997 年
3人推荐
4位读者提及
4次提及
“在这部对其首本 SQL Puzzles 著作的全面修订与扩充版中，Joe Celko 用他最棘手的难题向你发起挑战——随后通过多种解法和解析帮助逐一攻克。Joe 展示了从 SQL 视角切入问题的思维过程，以帮助高级数据库程序员解决常遇到的谜题。这些技巧不仅有助于解决眼前的难题，更能培养应对日常复杂 SQL 难题所需的思维方式。当然，其中的一部分乐趣还在于看看你是否能写出更
Hacker News 上怎么说
正在加载完整评论……
Joe Celko 的《SQL For Smarties》和《SQL Puzzles and Answers》是该领域的经典之作。虽然都出了 10 多年了，但依然非常实用，毕竟这段时间里 SQL 的变化远没有像 Java 那么大。http://www.celko.com/books.htm
Joe Celko's "SQL For Smarties" and "SQL Puzzles and Answers" are classics in the field. They're still very relevant despite being 10+ years old, since SQL hasn't changed anywhere near as much as, say, Java in that time. http://www.celko.com/books.htm
说实话，你选对了。它限制很多，所以你学到的东西适用面会非常广。听我一句劝，去搞本 Joe Celko 写的 SQL 书，比如《SQL Puzzles and Answers》。照着学下来，你就会掌握如何在各种方言或其他限制下搞定各种查询。真的能彻底打开思路。我发现自己在 SQLite 里做到了以前想都没想过…
Honestly, you picked the right one. It's restricted, so what you learn will be widely applicable. Do yourself a favor and pick up some books about SQL by Joe Celko's SQL Puzzles and Answers. If you follow it, you will learn how to accomplish various queries while having restrictions on dialects or whatever. It's a real mind-expander. I found myself doing in SQLite things I hadn't thought…
去看看 Joe Celko 的《SQL Puzzles and Answers》吧。
Take a look at Joe Celko's SQL Puzzles and Answers.
Celko 的《SQL Puzzles and Answers》：http://www.amazon.com/Puzzles-Answers-Kaufmann-Management-eb...
Celko's SQL Puzzles and Answers: http://www.amazon.com/Puzzles-Answers-Kaufmann-Management-eb...