SQL Pocket Guide

This pocket guide presents the most crucial information about SQL in a compact and easily accessible format, covering the four commonly used SQL variants--Oracle, IBM DB2, Microsoft SQL Server, and MySQL. Topics include:

• Data manipulation statements (SELECT, DELETE, INSERT, UPDATE, MERGE) and transaction control statements (START TRANSACTION, SAVEPOINT, COMMIT, ROLLBACK).
• Common SQL functions (date, numeric, math, trigonometric, string, conversion, aggregate)
• Such topics as literals, NULLs, CASE expressions, datatype conversion, regular expressions, grouping and summarizing data, joining tables, and writing queries (hierarchical, recursive, union, flashback) and subqueries.
• Instead of presenting complex and confusing syntax diagrams, the book teaches by example, showing the SQL statements and options that readers are most like to use. All example data is available on the O'Reilly web site.

Избранные страницы

Содержание

Introduction

Organization of This Book

Conventions

Acknowledgments

CASE Expressions

Searched CASE Expressions

Datatype Conversion

ANSIISO EXTRACT Function

Text Literals

Numeric Literals

Datetime Literals

Merging Data

Using CASE with NULLs

Functions for NULLs Oracle

Datetime Conversions Oracle

Numeric Conversions Oracle

Miscellaneous Conversions Oracle

Numeric Conversions DB2

Miscellaneous Conversions DB2

Numeric Conversions SQL Server

Miscellaneous Conversions SQL Server

Numeric Conversions MySQL

Deleting Data

Deleting All Rows

Deleting from Views and Subqueries

Returning the Deleted Data Oracle

DoubleFROM SQL Server

Flashback Queries Oracle

Date Functions

Numeric and Math Functions

Trigonometric Functions

Miscellaneous Functions Oracle

Useful GROUP BY Techniques

GROUP BY Extensions Oracle

GROUP BY Extensions SQL Server

Hierarchical Queries

CONNECT BY Syntax Oracle

Inserting Data

Insert Targets

DirectPath Inserts Oracle

MultiTable Inserts Oracle

Joining Tables

Cross Joins

NonEquiJoins

Functions for NULLs DB2

Predicates

Group Comparison Predicates

Multiple Values on the Left Oracle

EXISTS Predicates

BETWEEN Predicates

Recursive Queries

Regular Expressions

Regular Expressions SQL Server

Regular Expressions MySQL

Selecting Data

The SELECT Clause

ALL and DISTINCT

The FROM Clause

The WHERE Clause

The ORDER BY Clause

Subqueries

The WITH Clause

WITH with Correlated Subqueries

Transaction Management

Starting a Transaction

Ending a Transaction

Aborting a Transaction

Aborting to a Transaction Savepoint

Union Queries

Order of Evaluation

Updating Data

New Values from a Subquery

Updating Through a Cursor

Updating a Partition Oracle

Другие издания - Просмотреть все

SQL Pocket Guide
Jonathan Gennick
Просмотр фрагмента - 2004

SQL Pocket Guide
Jonathan Gennick
Просмотр фрагмента - 2004

Часто встречающиеся слова и выражения

Об авторе (2004)

Jonathan Gennick is an O'Reilly & Associates editor specializing in database and programming titles. Prior to joining O'Reilly, Jonathan amassed some 17 years of programming and database management experience. During the latter part of his career he specialized in relational database programming, and more recently in database management. Jonathan got his start with relational database systems in 1990, first working with Ingres, and later with Digital's Rdb software. During that period he developed a fondness for SQL, and for the challenge of applying SQL creatively in ways that leveraged it's set-oriented capabilities. In 1994 Jonathan made the leap to Oracle, and is now often found writing about it. Recent projects include Oracle SQLLoader (O'Reilly & Associates, 2001); Oracle SQLPlus Pocket Reference (O'Reilly & Associates, 2000); Oracle SQL*Plus: The Definitive Guide (O'Reilly & Associates, 1999); More recently, Jonathan has made forays into other database products, coauthoring Transact-SQL Cookbook (O'Reilly & Associates, 2002) and editing Practical PostgreSQL (O'Reilly & Associates, 2002). Jonathan is certified as an Oracle DBA and is a member of MENSA and the Oracle Technology Network. He holds a Bachelor of Arts degree in Information and Computer Science, with a Business Administration minor, from Andrews University in Berrien Springs, Michigan. Jonathan currently resides in Munising, Michigan with his wife Donna and their two children: Jenny and Jeff. Jonathan may be contacted by email at jonathan@gennick.com, and you can learn more about him personally by visiting his website athttp://gennick.com.

Библиографические данные