Joe Celko's SQL Puzzles and Answers

by Celko

• ISBN13: 9780123735966
• ISBN10: 0123735963
• Edition: 2nd
• Format: Paperback
• Copyright: 2006-09-21
• Publisher: Elsevier Science

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.