skip to content
SQL pocket guide Preview this item
ClosePreview this item

SQL pocket guide

Author: Jonathan Gennick
Publisher: Beijing ; Sebastopol, CA : O'Reilly, 2004.
Edition/Format:   Print book : English : 1st edView all editions and formats

Designed as a major help to programmers who use SQL in their day-to-day work, this title is not just an endless collection of syntax diagrams; it addresses the language's complexity head on and leads  Read more...


(not yet rated) 0 with reviews - Be the first.

More like this


Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...


Document Type: Book
All Authors / Contributors: Jonathan Gennick
ISBN: 0596005121 9780596005122
OCLC Number: 57000792
Notes: "A guide to SQL usage"--Cover.
"Oracle, DB2, SQL server & MySQL"--Cover.
Includes index.
Description: vi, 154 pages ; 18 cm
Contents: Introduction Organization of This Book Feedback Needed! Conventions Acknowledgments Example Data CASE Expressions Simple CASE Expressions Searched CASE Expressions Datatype Conversions ANSI/ISO CAST Function ANSI/ISO EXTRACT Function Datetime Conversions (Oracle) Numeric Conversions (Oracle) Miscellaneous Conversions (Oracle) Datetime Conversions (DB2) Numeric Conversions (DB2) Miscellaneous Conversions (DB2) Datetime Conversions (SQL Server) Numeric Conversions (SQL Server) Miscellaneous Conversions (SQL Server) Datetime Conversions (MySQL) Numeric Conversions (MySQL) Deleting Data Deleting All Rows Deleting from Views and Subqueries Deleting from Partitions (Oracle) Returning the Deleted Data (Oracle) Double-FROM (SQL Server) Flashback Queries (Oracle) Functions Date Functions Numeric and Math Functions Trigonometric Functions String Functions Miscellaneous Functions (Oracle) Grouping and Summarizing Aggregate Functions GROUP BY Useful GROUP BY Techniques HAVING GROUP BY Extensions (Oracle) GROUP BY Extensions (SQL Server) Hierarchical Queries Recursive WITH (ANSI/ISO) CONNECT BY Syntax (Oracle) Inserting Data Single-Row Inserts Insert Targets Subquery Inserts Direct-Path Inserts (Oracle) RETURNing Inserted Values (Oracle) Multi-Table Inserts (Oracle) Joining Tables The Concept of a Join Cross Joins Inner Joins Non-Equi-Joins Outer Joins Literals Text Literals Numeric Literals Datetime Literals Datetime Interval Literals Merging Data NULLs Predicates for NULLs Using CASE with NULLs Oracle Functions for NULLs DB2 Functions for NULLs SQL Server Functions for NULLs MySQL Functions for NULLs Predicates Group Comparison Predicates Multiple Values on the Left (Oracle) EXISTS Predicates IN Predicates BETWEEN Predicates LIKE Predicates Recursive Queries Regular Expressions Oracle Regular Expressions SQL Server Regular Expressions MySQL Regular Expressions Selecting Data The SELECT Clause ALL and DISTINCT The FROM Clause The WHERE Clause The GROUP BY Clause The HAVING Clause The ORDER BY Clause Subqueries The WITH Clause WITH with Correlated Subqueries Transaction Management Autocommit Mode Starting a Transaction Ending a Transaction Aborting a Transaction Aborting to a Transaction Savepoint Union Queries UNION and UNION ALL Order of Evaluation EXCEPT (or MINUS) INTERSECT Updating Data Simple Updates New Values from a Subquery Updating Through a Cursor (DB2 and SQL Server) Updating Views and Subqueries Updating a Partition (Oracle) Returning the Updated Data (Oracle) UPDATE FROM Clause (SQL Server)
Other Titles: Structured Query Language pocket guide
Responsibility: Jonathan Gennick.
More information:


User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...


Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data

Primary Entity

<> # SQL pocket guide
    a schema:CreativeWork, schema:Book ;
    library:oclcnum "57000792" ;
    library:placeOfPublication <> ; # Sebastopol, CA
    library:placeOfPublication <> ; # Beijing
    library:placeOfPublication <> ;
    schema:about <> ; # Database management
    schema:about <> ; # SQL (Computer program language)
    schema:about <> ;
    schema:about <> ; # Relational databases
    schema:alternateName "Structured Query Language pocket guide" ;
    schema:bookEdition "1st ed." ;
    schema:bookFormat bgn:PrintBook ;
    schema:creator <> ; # Jonathan Gennick
    schema:datePublished "2004" ;
    schema:exampleOfWork <> ;
    schema:inLanguage "en" ;
    schema:name "SQL pocket guide"@en ;
    schema:productID "57000792" ;
    schema:publication <> ;
    schema:publisher <> ; # O'Reilly
    schema:workExample <> ;
    wdrs:describedby <> ;

Related Entities

<> # Jonathan Gennick
    a schema:Person ;
    schema:familyName "Gennick" ;
    schema:givenName "Jonathan" ;
    schema:name "Jonathan Gennick" ;

<> # Sebastopol, CA
    a schema:Place ;
    schema:name "Sebastopol, CA" ;

<> # Relational databases
    a schema:Intangible ;
    schema:name "Relational databases"@en ;

<> # SQL (Computer program language)
    a schema:Intangible ;
    schema:name "SQL (Computer program language)"@en ;

<> # Database management
    a schema:Intangible ;
    schema:name "Database management"@en ;

    a schema:ProductModel ;
    schema:isbn "0596005121" ;
    schema:isbn "9780596005122" ;

Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.