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 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 t...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
San Francisco, Calif. :
Morgan Kaufmann Publishers
c2007.
|
| Edición: | 2nd ed |
| Colección: | Morgan Kaufmann series in data management systems.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627313706719 |
Tabla de Contenidos:
- Front Cover; Joe Celko's Sql Puzzles & Answers; Copyright Page; CONTENTS; Introduction; Acknowledgments, Corrections, and Future Editions; Part: Puzzle; Chapter 1. Fiscal Year Tables; Chapter 2. Absentees; Chapter 3. The Anesthesia Puzzle; Chapter 4. Security Badges; Chapter 5. Alpha Data; Chapter 6. Hotel Reservations; Chapter 7. Keeping A Portfolio; Chapter 8. Scheduling Printers; Chapter 9. Available Seats; Chapter 10. Wages of Sin; Chapter 11. Work Orders; Chapter 12. Claims Status; Chapter 13. Teachers; Chapter 14. Telephone; Chapter 15. Find The Last Two Salaries; Chapter 16. Mechanics
- Chapter 17. Employment AgencyChapter 18. Junk Mail; Chapter 19. Top Salespeople; Chapter 20. Test Results; Chapter 21. Airplanes And Pilots; Chapter 22. Landlord; Chapter 23. Magazine; Chapter 24. One In Ten; Chapter 25. Milestone; Chapter 26. Dataflow Diagrams; Chapter 27. Finding Equal Sets; Chapter 28. Calculate The Sine Function; Chapter 29. Find The Mode Computation; Chapter 30. Average Sales Wait; Chapter 31. Buying All The Products; Chapter 32. Computing Taxes; Chapter 33. Computing Depreciation; Chapter 34. Consultant Billing; Chapter 35. Inventory Adjustments; Chapter 36. Double Duty
- Chapter 37. A Moving AverageChapter 38. Journal Updating; Chapter 39. Insurance Losses; Chapter 40. Permutations; Chapter 41. Budgeting; Chapter 42. Counting Fish; Chapter 43. Graduation; Chapter 44. Pairs Of Styles; Chapter 45. Pepperoni Pizza; Chapter 46. Sales Promotions; Chapter 47. Blocks Of Seats; Chapter 48. Ungrouping; Chapter 49. Widget Count; Chapter 50. Two Of Three; Chapter 51. Budget Versus Actual; Chapter 52. Personnel Problem; Chapter 53. Collapsing A Table By Columns; Chapter 54. Potential Duplicates; Chapter 55. Playing The Ponies; Chapter 56. Hotel Room Numbers
- Chapter 57. Gaps-version OneChapter 58. Gaps-version Two; Chapter 59. Merging Time Periods; Chapter 60. Barcodes; Chapter 61. Sort A String; Chapter 62. Report Formatting; Chapter 63. Contiguous Groupings; Chapter 64. Boxes; Chapter 65. Age Ranges For Products; Chapter 66. Sudoku; Chapter 67. Stable Marriages Problem; Chapter 68. Catching The Next Bus; Chapter 69. Lifo-fifo Inventory; Chapter 70. Stock Trends; Chapter 71. Calculations; Chapter 72. Scheduling Service Calls; Chapter 73. A Little Data Scrubbing; Chapter 74. Derived Tables Or Not?; Chapter 75. Finding A Pub; Index
- About the Author
