Normal view MARC view ISBD view

SQL Cookbook : (Record no. 21539)

MARC details
000 -LEADER
fixed length control field	03939nam a22002177a 4500
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
ISBN	9789385889554
041 ## - LANGUAGE CODE
Language code of text/sound track or separate title	English
082 ## - DEWEY DECIMAL CLASSIFICATION NUMBER
Classification number	005.7585
Item number	MOL
100 ## - MAIN ENTRY--AUTHOR NAME
Author name	Molinaro, Anthony
245 ## - TITLE STATEMENT
Title	SQL Cookbook :
Sub Title	query solutions and techniques for all SQL users /
Statement of responsibility, etc	Anthony Molinaro and Robert de Graaf.
250 ## - EDITION STATEMENT
Edition statement	2nd ed.
260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)
Place of publication	New Delhi :
Name of publisher	O'Reilly Media, Incorporated,
Year of publication	2020
300 ## - PHYSICAL DESCRIPTION
Number of Pages	xx, 547 pages ;
Dimensions	25 cm.
505 ## - FORMATTED CONTENTS NOTE
Formatted contents note	Intro --<br/>Copyright --<br/>Table of Contents --<br/>Preface --<br/>Who This Book Is For --<br/>What's Missing from This Book --<br/>Platform and Version --<br/>Tables Used in This Book --<br/>Conventions Used in This Book --<br/>Typographical Conventions --<br/>Coding Conventions --<br/>O'Reilly Online Learning --<br/>How to Contact Us --<br/>Second Edition Acknowledgments --<br/>First Edition Acknowledgments --<br/>Chapter 1. Retrieving Records --<br/>1.1 Retrieving All Rows and Columns from a Table --<br/>Problem --<br/>Solution --<br/>Discussion --<br/>1.2 Retrieving a Subset of Rows from a Table --<br/>Problem --<br/>Solution --<br/>Discussion 1.3 Finding Rows That Satisfy Multiple Conditions --<br/>Problem --<br/>Solution --<br/>Discussion --<br/>1.4 Retrieving a Subset of Columns from a Table --<br/>Problem --<br/>Solution --<br/>Discussion --<br/>1.5 Providing Meaningful Names for Columns --<br/>Problem --<br/>Solution --<br/>Discussion --<br/>1.6 Referencing an Aliased Column in the WHERE Clause --<br/>Problem --<br/>Solution --<br/>Discussion --<br/>1.7 Concatenating Column Values --<br/>Problem --<br/>Solution --<br/>Discussion --<br/>1.8 Using Conditional Logic in a SELECT Statement --<br/>Problem --<br/>Solution --<br/>Discussion --<br/>1.9 Limiting the Number of Rows Returned --<br/>Problem --<br/>Solution --<br/>Discussion 1.10 Returning n Random Records from a Table --<br/>Problem --<br/>Solution --<br/>Discussion --<br/>1.11 Finding Null Values --<br/>Problem --<br/>Solution --<br/>Discussion --<br/>1.12 Transforming Nulls into Real Values --<br/>Problem --<br/>Solution --<br/>Discussion --<br/>1.13 Searching for Patterns --<br/>Problem --<br/>Solution --<br/>Discussion --<br/>1.14 Summing Up --<br/>Chapter 2. Sorting Query Results --<br/>2.1 Returning Query Results in a Specified Order --<br/>Problem --<br/>Solution --<br/>Discussion --<br/>2.2 Sorting by Multiple Fields --<br/>Problem --<br/>Solution --<br/>Discussion --<br/>2.3 Sorting by Substrings --<br/>Problem --<br/>Solution --<br/>Discussion 2.4 Sorting Mixed Alphanumeric Data --<br/>Problem --<br/>Solution --<br/>Discussion --<br/>2.5 Dealing with Nulls When Sorting --<br/>Problem --<br/>Solution --<br/>Discussion --<br/>2.6 Sorting on a Data-Dependent Key --<br/>Problem --<br/>Solution --<br/>Discussion --<br/>2.7 Summing Up --<br/>Chapter 3. Working with Multiple Tables --<br/>3.1 Stacking One Rowset atop Another --<br/>Problem --<br/>Solution --<br/>Discussion --<br/>3.2 Combining Related Rows --<br/>Problem --<br/>Solution --<br/>Discussion --<br/>3.3 Finding Rows in Common Between Two Tables --<br/>Problem --<br/>Solution --<br/>Discussion --<br/>3.4 Retrieving Values from One Table That Do Not Exist in Another --<br/>Problem Solution --<br/>Discussion --<br/>3.5 Retrieving Rows from One Table That Do Not Correspond to Rows in Another --<br/>Problem --<br/>Solution --<br/>Discussion --<br/>3.6 Adding Joins to a Query Without Interfering with Other Joins --<br/>Problem --<br/>Solution --<br/>Discussion --<br/>See Also --<br/>3.7 Determining Whether Two Tables Have the Same Data --<br/>Problem --<br/>Solution --<br/>Discussion --<br/>3.8 Identifying and Avoiding Cartesian Products --<br/>Problem --<br/>Solution --<br/>Discussion --<br/>3.9 Performing Joins When Using Aggregates --<br/>Problem --<br/>Solution --<br/>Discussion --<br/>3.10 Performing Outer Joins When Using Aggregates --<br/>Problem --<br/>Solution
520 ## - SUMMARY, ETC.
Summary, etc	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.
650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM
Subject	SQL (Computer program language)
650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM
Subject	Query languages (Computer science)
650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM
Subject	Database management.
700 ## - ADDED ENTRY--PERSONAL NAME
Author 2/ Editor	De Graaf, Robert
942 ## - ADDED ENTRY ELEMENTS (KOHA)
Source of classification or shelving scheme	Dewey Decimal Classification
Koha item type	Books

Holdings
Withdrawn status	Lost status	Source of classification or shelving scheme	Damaged status	Not for loan	Home library	Current library	Shelving location	Date acquired	Source of acquisition	Cost, normal purchase price	Bill Date	Full call number	Accession Number	Price effective from	Koha item type
		Dewey Decimal Classification			Institute of Public Enterprise, Library	Institute of Public Enterprise, Library	S Campus	02/15/2022	Overseas India Press	1800.00	29.01.2022	005.7585 MOL	45980	02/15/2022	Books
		Dewey Decimal Classification			Institute of Public Enterprise, Library	Institute of Public Enterprise, Library	S Campus	02/15/2022	Overseas India Press	1800.00	29.01.2022	005.7585 MOL	45979	02/15/2022	Books

SQL Cookbook : (Record no. 21539)

You are Visitor Number