SQL Cookbook : query solutions and techniques for all SQL users /
Anthony Molinaro and Robert de Graaf.
- 2nd ed.
- New Delhi : O'Reilly Media, Incorporated, 2020
- xx, 547 pages ; 25 cm.
Intro -- Copyright -- Table of Contents -- Preface -- 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
You may know SQL basics, but are you taking advantage of its expressive power? This second edition applies a highly practical approach to Structured Query Language (SQL) so you can create and manipulate large stores of data.
9789385889554
SQL (Computer program language) Query languages (Computer science) Database management.