Joe Celko's SQL Puzzles and Answers (eBook)

Joe Celko (Autor)

eBook Download: PDF

2006 | 2. Auflage
352 Seiten
Elsevier Science (Verlag)
978-0-08-049168-4 (ISBN)

Infos

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's SQL Puzzles and Answers, Second Edition, challenges you with his trickiest puzzles and then helps solve them with a variety of solutions and explanations. Author Joe Celko 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 also help develop the mindset needed to solve the many difficult SQL puzzles you face every day. This updated edition features many new puzzles; dozens of new solutions to puzzles; and new chapters on temporal query puzzles and common misconceptions about SQL and RDBMS that leads to problems. This book is recommended for database programmers with a good knowledge of SQL. - 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

Inhalt

Front Cover 1
Joe Celko's Sql Puzzles & Answers
Copyright Page 9
CONTENTS 12
Introduction 16
Acknowledgments, Corrections, and Future Editions 17
Part: Puzzle 20
Chapter 1. Fiscal Year Tables 20
Chapter 2. Absentees 23
Chapter 3. The Anesthesia Puzzle 28
Chapter 4. Security Badges 35
Chapter 5. Alpha Data 38
Chapter 6. Hotel Reservations 40
Chapter 7. Keeping A Portfolio 43
Chapter 8. Scheduling Printers 48
Chapter 9. Available Seats 53
Chapter 10. Wages of Sin 56
Chapter 11. Work Orders 64
Chapter 12. Claims Status 67
Chapter 13. Teachers 72
Chapter 14. Telephone 75
Chapter 15. Find The Last Two Salaries 79
Chapter 16. Mechanics 88
Chapter 17. Employment Agency 94
Chapter 18. Junk Mail 99
Chapter 19. Top Salespeople 101
Chapter 20. Test Results 105
Chapter 21. Airplanes And Pilots 107
Chapter 22. Landlord 111
Chapter 23. Magazine 113
Chapter 24. One In Ten 122
Chapter 25. Milestone 126
Chapter 26. Dataflow Diagrams 131
Chapter 27. Finding Equal Sets 134
Chapter 28. Calculate The Sine Function 140
Chapter 29. Find The Mode Computation 142
Chapter 30. Average Sales Wait 145
Chapter 31. Buying All The Products 148
Chapter 32. Computing Taxes 151
Chapter 33. Computing Depreciation 156
Chapter 34. Consultant Billing 160
Chapter 35. Inventory Adjustments 164
Chapter 36. Double Duty 167
Chapter 37. A Moving Average 171
Chapter 38. Journal Updating 174
Chapter 39. Insurance Losses 177
Chapter 40. Permutations 182
Chapter 41. Budgeting 188
Chapter 42. Counting Fish 191
Chapter 43. Graduation 195
Chapter 44. Pairs Of Styles 198
Chapter 45. Pepperoni Pizza 202
Chapter 46. Sales Promotions 205
Chapter 47. Blocks Of Seats 209
Chapter 48. Ungrouping 211
Chapter 49. Widget Count 219
Chapter 50. Two Of Three 222
Chapter 51. Budget Versus Actual 227
Chapter 52. Personnel Problem 231
Chapter 53. Collapsing A Table By Columns 234
Chapter 54. Potential Duplicates 237
Chapter 55. Playing The Ponies 240
Chapter 56. Hotel Room Numbers 243
Chapter 57. Gaps—version One 246
Chapter 58. Gaps—version Two 249
Chapter 59. Merging Time Periods 253
Chapter 60. Barcodes 256
Chapter 61. Sort A String 261
Chapter 62. Report Formatting 263
Chapter 63. Contiguous Groupings 273
Chapter 64. Boxes 276
Chapter 65. Age Ranges For Products 280
Chapter 66. Sudoku 282
Chapter 67. Stable Marriages Problem 286
Chapter 68. Catching The Next Bus 299
Chapter 69. Lifo-fifo Inventory 302
Chapter 70. Stock Trends 311
Chapter 71. Calculations 316
Chapter 72. Scheduling Service Calls 319
Chapter 73. A Little Data Scrubbing 323
Chapter 74. Derived Tables Or Not? 325
Chapter 75. Finding A Pub 328
Index 332
About the Author 346

Produkt-Details

• Erscheint lt. Verlag: 9.10.2006
• Sprache: englisch
• Themenwelt: Sachbuch/Ratgeber
• Themenwelt: Mathematik / Informatik ► Informatik ► Datenbanken
• Themenwelt: Mathematik / Informatik ► Informatik ► Programmiersprachen / -werkzeuge
• Themenwelt: Mathematik / Informatik ► Informatik ► Software Entwicklung
• ISBN-10: 0-08-049168-5 / 0080491685
• ISBN-13: 978-0-08-049168-4 / 9780080491684