SQL cookbook : query solutions and techniques for all SQL users /
Anthony Molinaro and Robert de Graaf
- Second Edition.
- Sebastopol, California : O'Reilly Media, Incorporated, c2020
- xx, 545 pages ; 24 cm.
Includes index.
Who This Book Is For -- What's Missing from This Book -- Platform and Version -- Tables Used in This Book -- Conventions Used in This Book -- Typographical Conventions -- Coding Conventions -- O'Reilly Online Learning -- How to Contact Us -- Second Edition Acknowledgments -- First Edition Acknowledgments -- Chapter 1. Retrieving Records -- 1.1 Retrieving All Rows and Columns from a Table -- Problem -- Solution -- Discussion -- 1.2 Retrieving a Subset of Rows from a Table -- Problem -- Solution -- Discussion 1.3 Finding Rows That Satisfy Multiple Conditions -- Problem -- Solution -- Discussion -- 1.4 Retrieving a Subset of Columns from a Table -- Problem -- Solution -- Discussion -- 1.5 Providing Meaningful Names for Columns -- Problem -- Solution -- Discussion -- 1.6 Referencing an Aliased Column in the WHERE Clause -- Problem -- Solution -- Discussion -- 1.7 Concatenating Column Values -- Problem -- Solution -- Discussion -- 1.8 Using Conditional Logic in a SELECT Statement -- Problem -- Solution -- Discussion -- 1.9 Limiting the Number of Rows Returned -- Problem -- Solution -- Discussion 1.10 Returning n Random Records from a Table -- Problem -- Solution -- Discussion -- 1.11 Finding Null Values -- Problem -- Solution -- Discussion -- 1.12 Transforming Nulls into Real Values -- Problem -- Solution -- Discussion -- 1.13 Searching for Patterns -- Problem -- Solution -- Discussion -- 1.14 Summing Up -- Chapter 2. Sorting Query Results -- 2.1 Returning Query Results in a Specified Order -- Problem -- Solution -- Discussion -- 2.2 Sorting by Multiple Fields -- Problem -- Solution -- Discussion -- 2.3 Sorting by Substrings -- Problem -- Solution -- Discussion 2.4 Sorting Mixed Alphanumeric Data -- Problem -- Solution -- Discussion -- 2.5 Dealing with Nulls When Sorting -- Problem -- Solution -- Discussion -- 2.6 Sorting on a Data-Dependent Key -- Problem -- Solution -- Discussion -- 2.7 Summing Up -- Chapter 3. Working with Multiple Tables -- 3.1 Stacking One Rowset atop Another -- Problem -- Solution -- Discussion -- 3.2 Combining Related Rows -- Problem -- Solution -- Discussion -- 3.3 Finding Rows in Common Between Two Tables -- Problem -- Solution -- Discussion -- 3.4 Retrieving Values from One Table That Do Not Exist in Another -- Problem Solution -- Discussion -- 3.5 Retrieving Rows from One Table That Do Not Correspond to Rows in Another -- Problem -- Solution -- Discussion -- 3.6 Adding Joins to a Query Without Interfering with Other Joins -- Problem -- Solution -- Discussion -- See Also -- 3.7 Determining Whether Two Tables Have the Same Data -- Problem -- Solution -- Discussion -- 3.8 Identifying and Avoiding Cartesian Products -- Problem -- Solution -- Discussion -- 3.9 Performing Joins When Using Aggregates -- Problem -- Solution -- Discussion -- 3.10 Performing Outer Joins When Using Aggregates -- Problem -- Solution.
SQL programmers, analysts, data scientists, database administrators, and even relatively casual SQL users will find SQL Cookbook to be a valuable problem-solving guide for everyday issues. No other resource offers recipes in this unique format to help you tackle nagging day-to-day conundrums with SQL.