Joe Celko's SQL Puzzles and Answers, 2/e

Joe Celko

  • 出版商: Morgan Kaufmann
  • 出版日期: 2006-10-01
  • 售價: $2,380
  • 貴賓價: 9.5$2,261
  • 語言: 英文
  • 頁數: 352
  • 裝訂: Paperback
  • ISBN: 0123735963
  • ISBN-13: 9780123735966
  • 相關分類: SQL
  • 立即出貨

買這商品的人也買了...

商品描述

Description  

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.

 

Table of Contents

PUZZLE 01: FISCAL YEAR TABLES
PUZZLE 02: ABSENTEES
PUZZLE 03: THE ANESTHESIA PUZZLE
PUZZLE 04: SECURITY BADGES
PUZZLE 05: ALPHA DATA
PUZZLE 06: HOTEL RESERVATIONS
PUZZLE 07: KEEPING A PORTFOLIO
PUZZLE 08: SCHEDULING PRINTERS
PUZZLE 09: AVAILABLE SEATS PUZZLE
PUZZLE 10: WAGES OF SIN:

PUZZLE 11: WORK ORDER
PUZZLE 12: CLAIMS STATUS
PUZZLE 13: TEACHERS
PUZZLE 14: TELEPHONE
PUZZLE 15: FIND THE LAST TWO SALARIES
PUZZLE 16: MECHANICS
PUZZLE 17: EMPLOYMENT AGENCY
PUZZLE 18: JUNK MAIL
PUZZLE 19: TOP SALESMEN
PUZZLE 20: TEST RESULTS

PUZZLE 21: AIRPLANES AND PILOTS
PUZZLE 22: LANDLORD
PUZZLE 23: MAGAZINE
PUZZLE 24 ONE IN TEN
PUZZLE 25: MILESTONE
PUZZLE 26: DATAFLOW DIAGRAMS
PUZZLE 27: FINDING EQUAL SETS
PUZZLE 28: CALCULATE THE SINE FUNCTION
PUZZLE 29: FIND THE MODE COMPUTATION
PUZZLE 30: AVERAGE SALES WAIT

PUZZLE 31: BUYING ALL THE PRODUCTS
PUZZLE 32: COMPUTING TAXES
PUZZLE 33: COMPUTING DEPRECIATION
PUZZLE 34: CONSULTANT BILLING
PUZZLE 35: REQUISITIONS
PUZZLE 36: DOUBLE DUTY
PUZZLE 37: MOVING AVERAGE
PUZZLE 38: JOURNAL UPDATING
PUZZLE 39: INSURANCE LOSSES
PUZZLE 40: PERMUTATIONS:

PUZZLE 41: BUDGETING
PUZZLE 42: COUNTING FISH
PUZZLE 43: GRADUATION
PUZZLE 44: PAIRS OF STYLES
PUZZLE 45: PEPPERONI PIZZA
PUZZLE 46: SALES PROMOTIONS
PUZZLE 47: BLOCKS OF SEATS
PUZZLE 48: UN-GROUPING
PUZZLE 49: WIDGET COUNT
PUZZLE 50: TWO OF THREE

PUZZLE 51: BUDGET VERSUS ACTUAL
PUZZLE 52: PERSONNEL PROBLEM
PUZZLE 53: COLLAPSING A TABLE BY COLUMNS
PUZZLE 54: POTENTIAL DUPLICATES
PUZZLE 55: PLAYING THE PONIES
PUZZLE 56: HOTEL ROOM NUMBERS
PUZZLE 57: GAPS - 1
PUZZLE 58: GAPS - 2
PUZZLE 59: MERGING TIME PERIODS
PUZZLE 60: BARCODES

PUZZLE 61: SORTING A STRING
PUZZLE 62: REPORT FORMATTING
PUZZLE 63: CONTIGUOUS GROUPINGS
PUZZLE 64: BOXES
PUZZLE 65: AGE RANGES FOR PRODUCTS
PUZZLE 66: FOUR CONSECUTIVE ABSENCES
PUZZLE 67: STABLE MARRIAGES PROBLEM
PUZZLE 68: CATCHING THE NEXT BUS
PUZZLE 69: LIFO-FIFO INVENTORY
PUZZLE 70: STOCK TRENDS

PUZZLE 71: CALCULATIONS
PUZZLE 72: SCHEDULING SERVICE CALLS
PUZZLE 73: A LITTLE DATA SCRUBBING

PUZZLE 74: DERIVED TABLES OR NOT?
PUZZLE 75: FINDING A PUB

 

商品描述(中文翻譯)

在這本《SQL Puzzles》的完整修訂和擴充版中,Joe Celko向您提出了他最棘手的謎題,並通過多種解決方案和解釋來幫助您解決這些謎題。Joe展示了攻擊問題的思維過程,從SQL的角度幫助高級數據庫程序員解決您經常面臨的謎題。這些技巧不僅有助於解決當前的謎題,還有助於培養解決每天面臨的許多困難SQL謎題所需的思維方式。當然,其中一部分樂趣就是看看您是否能寫出比Joe更好的解決方案。

目錄:

PUZZLE 01: 財政年表
PUZZLE 02: 缺席者
PUZZLE 03: 麻醉謎題
PUZZLE 04: 安全證件
PUZZLE 05: ALPHA數據
PUZZLE 06: 酒店預訂
PUZZLE 07: 維護投資組合
PUZZLE 08: 調度打印機
PUZZLE 09: 可用座位謎題
PUZZLE 10: 罪惡的工資

PUZZLE 11: 工作訂單
PUZZLE 12: 請求狀態
PUZZLE 13: 教師
PUZZLE 14: 電話
PUZZLE 15: 找到最後兩個工資
PUZZLE 16: 修理工
PUZZLE 17: 就業機構
PUZZLE 18: 垃圾郵件
PUZZLE 19: 銷售冠軍
PUZZLE 20: 測試結果

PUZZLE 21: 飛機和飛行員
PUZZLE 22: 房東
PUZZLE 23: 雜誌
PUZZLE 24: 十分之一
PUZZLE 25: 里程碑
PUZZLE 26: 數據流程圖
PUZZLE 27: 查找相等集合
PUZZLE 28: 計算正弦函數
PUZZLE 29: 查找模式計算
PUZZLE 30: 平均銷售等待

PUZZLE 31: 購買所有產品
PUZZLE 32: 計算稅金
PUZZLE 33: 計算折舊
PUZZLE 34: 顧問計費
PUZZLE 35: 請求
PUZZLE 36: 雙重職責
PUZZLE 37: 移動平均
PUZZLE 38: 更新日誌
PUZZLE 39: 保險損失
PUZZLE 40: 排列組合

PUZZLE 41: 預算編制
PUZZLE 42: 計數魚
PUZZLE 43: 畢業
PUZZLE 44: 樣式對
PUZZLE 45: 意大利辣香腸披薩
PUZZLE 46: 銷售促銷
PUZZLE 47: 座位區塊
PUZZLE 48: 取消分組
PUZZLE 49: 部件計數
PUZZLE 50: 三個中的兩個

PUZZLE 51: 預算與實際
PUZZLE 52: 人事問題
PUZZLE 53: 按列折疊表格
PUZZLE 54: 潛在重複
PUZZLE 55: 賽馬
PUZZLE 56: 酒店房間號碼
PUZZLE 57: 空缺-1
PUZZLE 58: 空缺-2
PUZZLE 59: 合併時間段