SQL Hacks > Reporting > Build Decision Tables - Pg. : Safari Books Online

Table of Contents

Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

This Book

SQL Hacks

Search

Contents

credits: Credits

Ch. 1. SQL Fundamentals

Ch. 2. Joins, Unions, and Views

Ch. 3. Text Handling

Ch. 4. Date Handling

Ch. 5. Number Crunching

Ch. 6. Online Applications

Ch. 7. Organizing Data

Ch. 8. Storing Small Amounts of Data

Ch. 9. Locking and Performance

Ch. 10. Reporting

Hack 77. Fill in Missing Values in a Pivot Table

Hack 78. Break It Down by Range

Hack 79. Identify Updates Uniquely

Hack 80. Play Six Degrees of Kevin Bacon

Hack 81. Build Decision Tables

Hack 82. Generate Sequential or Missing Data

Hack 83. Find the Top n in Each Group

Hack 84. Store Comma-Delimited Lists in a Column

Hack 85. Traverse a Simple Tree

Hack 86. Set Up Queuing in the Database

Hack 87. Generate a Calendar

Hack 88. Test Two Values from a Subquery

Hack 89. Choose Any Three of Five

Ch. 11. Users and Administration

Ch. 12. Wider Access

URL

Help

Hack 81. Build Decision Tables

When you need a query to make decisions based on multiple criteria you can hardcode the logic into a query, or you can use a decision table.

You are currently reading a PREVIEW of this book.

Get instant access to over
$1 million worth of books and videos.

Start a Free Trial