
SQL puzzles & answers
Joe Celko · 1997
Programming and computer science › Databases and distributed data
#8,360 most recommended
Hacker News
4
mentions by 4 people · top 54% of 15,732 books
Open Library
—
No ratings yet
Wikipedia
—
No article yet
About the book
A collection of tricky SQL puzzles for advanced database programmers, each followed by one or more worked solutions and explanations. Its scope covers query design across SQL-99 and later standards, the SQL Style coding conventions, and temporal query problems. The central claim is that solving SQL problems depends on a set-oriented way of thinking, which the author develops by working through each puzzle from the SQL perspective rather than with procedural habits. The book holds that one puzzle often admits several valid solutions, and it invites readers to compare their own against the author's. It also identifies common misconceptions about SQL and relational database systems that lead to faulty queries.
Written by Claude from what it knows of this book.
What Hacker News says 75% recommend · 0% critical
In the commenters’ own words
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…
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…
What Open Library readers say
No Open Library reader has rated it yet.
What critics say, via Wikipedia
No Wikipedia article about this book yet, so no critics to quote.
Reddit communities — coming later
The threads it came up in
Details
- First published
- 1997
- ISBN
- 9780123735966
- Editions known
- 4 at Open Library
- Open Library
- OL2629232W
SQL (Computer program language)
Read next: its neighbours on the mosaic
Joe Celko's SQL for SmartiesJoe Celko · 1995 · recommended by 10 people · similar by subject and what people say about it
Java puzzlersJoshua Bloch · 2005 · recommended by 12 people · similar by subject and what people say about it
Practical SQL, 2nd EditionAnthony DeBarros · 2021 · recommended by 5 people · similar by subject and what people say about it
SQL for Web NerdsPhilip Greenspun · 2000 · recommended by 7 people · similar by subject and what people say about it
SQL Design PatternsVadim Tropashko · 2007 · recommended by 2 people · similar by subject and what people say about it
Using SQLiteJay A. Kreibich · 2010 · recommended by 1 person · loosely similar by subject
The art of SQLStephane Faroult · 2006 · recommended by 8 people · similar by subject and what people say about it
Joe Celko's Trees and Hierarchies in SQL for Smarties,Joe Celko · 2004 · recommended by 5 people · similar by subject and what people say about it
SQL for DummiesAllen G. Taylor · 1993 · recommended by 1 person · similar by subject and what people say about it
SQL Queries for Mere MortalsJohn L. Viescas · 2018 · recommended by 2 people · similar by subject and what people say about it
Sams teach yourself SQL in 10 minutesBen Forta · 1999 · recommended by 0 people · similar by subject and what people say about it
SQL antipatternsBill Karwin · 2010 · recommended by 31 people · similar by subject and what people say about it
Algorithmic puzzlesAnany Levitin · 2011 · recommended by 1 person · similar by subject and what people say about it
SQL CookbookAnthony Molinaro · 2005 · recommended by 7 people · similar by subject and what people say about it
The C puzzle bookAlan R. Feuer · 1982 · recommended by 10 people · similar by subject and what people say about it
The Gödelian puzzle bookRaymond M. Smullyan · 2013 · recommended by 2 people · similar by subject and what people say about it
SQL and relational theoryC. J. Date · 2009 · recommended by 9 people · similar by subject and what people say about it
C Traps and PitfallsAndrew Koenig · 1989 · recommended by 19 people · similar by subject and what people say about it
Learning SQLAlan Beaulieu · 2005 · recommended by 3 people · similar by subject and what people say about it
Aha! InsightMartin Gardner · 1978 · recommended by 4 people · similar by subject and what people say about it
Winning Ways for Your Mathematical PlaysElwyn R. Berlekamp · 1982 · recommended by 16 people · similar by subject and what people say about it
Database System ConceptsKorth · 2005 · recommended by 4 people · similar by subject and what people say about it
Programming interviews exposedJohn Mongan · 2007 · recommended by 29 people · similar by subject and what people say about it
Developing time-oriented database applications in SQLRichard T. Snodgrass · 1999 · recommended by 6 people · loosely similar by subject