Amazon cover image
Image from Amazon.com

SQL Cookbook : query solutions and techniques for all SQL users / Anthony Molinaro and Robert de Graaf.

By: Contributor(s): Material type: TextTextLanguage: English Publication details: New Delhi : O'Reilly Media, Incorporated, 2020Edition: 2nd edDescription: xx, 547 pages ; 25 cmISBN:
  • 9789385889554
Subject(s): DDC classification:
  • 005.7585 MOL
Contents:
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
Summary: 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.
Tags from this library: No tags from this library for this title. Log in to add tags.
Star ratings
    Average rating: 0.0 (0 votes)

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.

There are no comments on this title.

to post a comment.

Maintained and Designed by
2cqr automation private limited, Chennai. All Rights Reserved.

You are Visitor Number

PHP Hits Count