在线阅读本书

In this complete revision and expansion of his first SQL Puzzles book, Joe Celko challenges you with his trickiest puzzles-and then helps solve them with a variety of solutions and explanations. Joe demonstrates the thought processes that are involved in attacking a problem from an SQL perspective to help advanced database programmers solve the puzzles you frequently face. These techniques not only help with the puzzle at hand, but help develop the mindset needed to solve the many difficult SQL puzzles you face every day. Of course, part of the fun is to see whether or not you can write better solutions than Joe's.

* A great collection of tricky SQL puzzles with a variety of solutions and explanations. * Uses the proven format of puzzles and solutions to provide a user-friendly, practical look into SQL programming problems - many of which will help users solve their own problems. * New edition features: - Many new puzzles added! - Dozens of new solutions to puzzles, and using features in SQL-99 - Code is edited to conform to SQL STYLE rules - New chapter on temporal query puzzles - New chapter on common misconceptions about SQL and RDBMS that leads to problems

Joe Celko 世界著名的数据库专家，曾担任ANSl SQL标准委员会成员达10年之久，参与了SQL-89和SQL-92标准的制定，是世界上读者数量最多的SQL图书作者之一。他曾撰写过一系列专栏，并通过他的新闻组支持和推动了数据库编程技术以及ANSl/ISO标准的发展。除本书外，他还撰写了多部SQL经典著作，包括《SQL编程风格》、《SQL解惑》和《SQL权威指南》，上述作品的中文版均已由人民邮电出版社出版。