9780123735966

Joe Celko's SQL Puzzles and Answers, Second Edition

by
  • ISBN13:

    9780123735966

  • ISBN10:

    0123735963

  • Edition: 2nd
  • Format: Paperback
  • Copyright: 2006-09-21
  • Publisher: Elsevier Science
  • Purchase Benefits
  • Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $67.95 Save up to $1.70
  • Buy New
    $66.25
    Add to Cart Free Shipping

    PRINT ON DEMAND: 2-4 WEEKS. THIS ITEM CANNOT BE CANCELLED OR RETURNED.

Supplemental Materials

What is included with this book?

  • The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
  • The eBook copy of this book is not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

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 better solutions than Joes. * 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

Table of Contents

Puzzle
Fiscal Year Tables Puzzle
absentees Puzzle
The Anesthesia Puzzle Puzzle
Security Badges Puzzle
Alpha Data Puzzle
Hotel Reservations Puzzle
Keeping A Portfolio Puzzle
Scheduling Printers Puzzle
Available Seats Puzzle Puzzle
Wages Of Sin: Puzzle
Work Order Puzzle
Claims Status Puzzle
Teachers Puzzle
Telephone Puzzle
Find The Last Two Salaries Puzzle
Mechanics Puzzle
Employment Agency Puzzle
Junk Mail Puzzle
Top Salesmen Puzzle
Test Results Puzzle
Airplanes And Pilots Puzzle
Landlord Puzzle
Magazine Puzzle
One In Ten Puzzle
Milestone Puzzle
Dataflow Diagrams Puzzle
Finding Equal Sets Puzzle
Calculate The Sine Function Puzzle
Find The Mode Computation Puzzle
Average Sales wait Puzzle
Buying All The Products Puzzle
Computing Taxes Puzzle
Computing Depreciation Puzzle
Consultant Billing Puzzle
Requisitions Puzzle
Double Duty Puzzle
Moving Average Puzzle
Journal Updating Puzzle
Insurance Losses Puzzle
Permutations: Puzzle
Budgeting Puzzle
Counting Fish Puzzle
Graduation Puzzle
Pairs Of Styles Puzzle
Pepperoni Pizza Puzzle
Sales Promotions Puzzle
Blocks Of Seats Puzzle
Un-grouping Puzzle
Widget Count Puzzle
Two Of Three Puzzle
Budget Versus Actual Puzzle
Personnel Problem Puzzle
Collapsing A Table By Columns Puzzle
Potential Duplicates Puzzle
Playing The Ponies Puzzle
Hotel Room Numbers Puzzle
Gaps - 1 Puzzle
Gaps - 2 Puzzle
Merging Time Periods Puzzle
Barcodes Puzzle
Sorting A String Puzzle
Report Formatting Puzzle
Contiguous Groupings Puzzle
Boxes Puzzle
Age Ranges For Products Puzzle
Four Consecutive Absences Puzzle
Stable Marriages Problem Puzzle
Catching The Next Bus Puzzle
Lifo-fifo Inventory Puzzle
Stock Trends Puzzle
Calculations Puzzle
Scheduling Service Calls Puzzle
A Little Data Scrubbing Puzzle
Derived Tables Or Not? Puzzle
Finding A Pub
Table of Contents provided by Publisher. All Rights Reserved.

Rewards Program

Write a Review