Joe Celko's SQL Puzzles & Answers

Front Cover
Morgan Kaufmann, 1997 - Computers - 192 pages
0 Reviews

Joe Celko challenges you with his trickiest puzzles and then helps you conquer them with a variety of solutions and explanations. The puzzles are a compilation from Joe's columns in DBMS and Database Programming & Design magazines. They include new, never-before-published puzzles plus new solutions and extra background for previously published puzzles. In his usual entertaining and informative style, Joe demonstrates the thought processes that are involved in attacking a problem from an SQL perspective. Through the practical, enjoyable puzzles, he introduces immediately useful new techniques and applications for SQL programming, and shows the database programmer how to write and use non-procedural programs.

  

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Defining Data
1
Formatting Data
41
Selecting Data
61
MECHANICS
62
EMPLOYMENT AGENCY
67
JUNK MAIL
72
TOP SALESPERSONS
74
TEST RESULTS
78
CONSULTANT BILLING
121
REQUISITION
125
DOUBLE DUTY
128
A MOVING AVERAGE
131
Grouping Data
135
BUDGETING REPORT
137
COUNTING FISH
141
GRADUATION
144

AIRPLANES AND PILOTS
80
LANDLORD
81
MAGAZINE
83
ONE IN TEN
86
MILESTONE
89
DATAFLOW DIAGRAMS
93
FINDING EQUAL SETS
96
Computing Things
101
CALCULATE THE SINE FUNCTION
102
FIND THE MODE
104
AVERAGE SALES WAIT
107
BUYING ALL THE PRODUCTS
110
TAX CALCULATIONS
113
DEPRECIATION
118
PAIRS OF STYLES
148
PEPPERONI
153
PROMO
154
BLOCKS OF SEATS
159
UNGROUPING
161
WIDGET
169
TWO OUT OF THREE
172
BUDGET VERSUS ACTUAL
175
PERSONNEL PROBLEM
178
PLAYING THE PONIES
181
HOTEL ROOMS
183
Index
187
Copyright

Common terms and phrases

References to this book

All Book Search results »

About the author (1997)

Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards.

Mr. Celko is author a series of books on SQL and RDBMS for Elsevier/MKP. He is an independent consultant based in Austin, Texas.

He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.

Bibliographic information