Joe Celko's SQL puzzles & answers /

In this complete revision and expansion of his first SQL Puzzles book, Joe Celko challenges you with his trickiest puzzlesand 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...

Full description

Saved in:
Bibliographic Details
Main Authors: Celko, Joe
Corporate Authors: Elsevier Science & Technology
Published: Morgan Kaufmann Publishers,
Publisher Address: San Francisco, Calif. :
Publication Dates: 2007.
Literature type: eBook
Language: English
Edition: Second edition.
Series: Morgan Kaufmann series in data management systems
Subjects:
Online Access: http://www.sciencedirect.com/science/book/9780123735966
Summary: In this complete revision and expansion of his first SQL Puzzles book, Joe Celko challenges you with his trickiest puzzlesand 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 bette
Carrier Form: 1 online resource (xvii, 325 pages) : illustrations.
ISBN: 9780123735966
0123735963
9780080491684
0080491685
Index Number: QA76
CLC: TP312SQ
Contents: PUZZLE 01: FISCAL YEAR TABLES -- PUZZLE 02: ABSENTEES -- PUZZLE 03: THE ANESTHESIA PUZZLE -- PUZZLE 04: SECURITY BADGES -- PUZZLE 05: ALPHA DATA -- PUZZLE 06: HOTEL RESERVATIONS -- PUZZLE 07: KEEPING A PORTFOLIO -- PUZZLE 08: SCHEDULING PRINTERS -- PUZZLE 09: AVAILABLE SEATS PUZZLE -- PUZZLE 10: WAGES OF SIN: -- PUZZLE 11: WORK ORDER -- PUZZLE 12: CLAIMS STATUS -- PUZZLE 13: TEACHERS -- PUZZLE 14: TELEPHONE -- PUZZLE 15: FIND THE LAST TWO SALARIES -- PUZZLE 16: MECHANICS -- PUZZLE 17: EMPLOYMENT AGENCY -- PUZZLE 18: JUNK MAIL -- PUZZLE 19: TOP SALESMEN -- PUZZLE 20: TEST RESULTS -- PUZZLE 21