000			04057nam a2200253Ia 4500
003			NULRC
005			20250520103030.0
008			250520s9999 xx 000 0 und d
020			_a9781492077442
040			_cNULRC
050			_aQA 76.9 .M65 2021
100			_aMolinaro, Anthony _eauthor
245		0	_aSQL cookbook : _bquery solutions and techniques for all SQL users / _cAnthony Molinaro and Robert de Graaf
250			_aSecond Edition.
260			_aSebastopol, California : _bO'Reilly Media, Incorporated, _cc2020
300			_axx, 545 pages ; _c24 cm.
365			_bUSD51
504			_aIncludes index.
505			_aWho 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.
520			_aSQL 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.
650			_aDATABASE MANAGEMENT
700			_ade Graaf, Robert _eco-author
942			_2lcc _cBK
999			_c21841 _d21841