TY - BOOK AU - Molinaro, Anthony AU - De Graaf, Robert TI - SQL Cookbook : : query solutions and techniques for all SQL users SN - 9789385889554 U1 - 005.7585 PY - 2020/// CY - New Delhi : PB - O'Reilly Media, Incorporated, KW - SQL (Computer program language) KW - Query languages (Computer science) KW - Database management N1 - 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 N2 - 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 ER -