SQL cookbook : (Record no. 21841)

MARC details
000 -LEADER
fixed length control field 04057nam a2200253Ia 4500
003 - CONTROL NUMBER IDENTIFIER
control field NULRC
005 - DATE AND TIME OF LATEST TRANSACTION
control field 20250520103030.0
008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION
fixed length control field 250520s9999 xx 000 0 und d
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
International Standard Book Number 9781492077442
040 ## - CATALOGING SOURCE
Transcribing agency NULRC
050 ## - LIBRARY OF CONGRESS CALL NUMBER
Classification number QA 76.9 .M65 2021
100 ## - MAIN ENTRY--PERSONAL NAME
Personal name Molinaro, Anthony
Relator term author
245 #0 - TITLE STATEMENT
Title SQL cookbook :
Remainder of title query solutions and techniques for all SQL users /
Statement of responsibility, etc. Anthony Molinaro and Robert de Graaf
250 ## - EDITION STATEMENT
Edition statement Second Edition.
260 ## - PUBLICATION, DISTRIBUTION, ETC.
Place of publication, distribution, etc. Sebastopol, California :
Name of publisher, distributor, etc. O'Reilly Media, Incorporated,
Date of publication, distribution, etc. c2020
300 ## - PHYSICAL DESCRIPTION
Extent xx, 545 pages ;
Dimensions 24 cm.
365 ## - TRADE PRICE
Price amount USD51
504 ## - BIBLIOGRAPHY, ETC. NOTE
Bibliography, etc. note Includes index.
505 ## - FORMATTED CONTENTS NOTE
Formatted contents note 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.
520 ## - SUMMARY, ETC.
Summary, etc. 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.
650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element DATABASE MANAGEMENT
700 ## - ADDED ENTRY--PERSONAL NAME
Personal name de Graaf, Robert
Relator term co-author
942 ## - ADDED ENTRY ELEMENTS (KOHA)
Source of classification or shelving scheme Library of Congress Classification
Koha item type Books
Holdings
Withdrawn status Lost status Source of classification or shelving scheme Damaged status Not for loan Collection Home library Current library Shelving location Date acquired Source of acquisition Cost, normal purchase price Total checkouts Full call number Barcode Date last seen Copy number Price effective from Koha item type
    Library of Congress Classification     Digital Forensic LRC - Main National University - Manila General Circulation 05/14/2024 Purchased - Amazon 51.00   GC QA 76.9 .M65 2021 NULIB000019600 05/20/2025 c.1 05/20/2025 Books