SQL Pocket Guide, 3rd Edition: A Guide to SQL Usage

206 Pages·2010·2.77 MB·English

by  Jonathan Gennick

www.it-ebooks.info
Download from www.eBookTM.com
www.it-ebooks.info
Download from www.eBookTM.com
www.it-ebooks.info
SQL
Pocket Guide
Download from www.eBookTM.com
www.it-ebooks.info
Download from www.eBookTM.com
www.it-ebooks.info
THIRD EDITION
SQL
Pocket Guide
Beijing • Cambridge • Farnham • Köln • Sebastopol • Tokyo
Jonathan Gennick
Download from www.eBookTM.com
www.it-ebooks.info
SQL Pocket Guide, Third Edition
by Jonathan Gennick
Copyright © 2011 Jonathan Gennick. All rights reserved.
Printed in the United States of America.
Published by O’Reilly Media, Inc., 1005 Gravenstein Highway North,
Sebastopol, CA 95472.
O’Reilly books may be purchased for educational, business, or sales promo-
tional use. Online editions are also available for most titles (http://my.safari
booksonline.com). For more information, contact our corporate/institutional
sales department: [phone] or
www.it-ebooks.info
Contents
SQL Pocket Guide 1
Introduction 1
Analytic Functions 7
CASE Expressions: Simple 7
CASE Expressions: Searched 7
CAST Function 8
CONNECT BY Queries 8
Data Type Conversion 15
Data Types: Binary Integer 15
Data Types: Character String 15
Data Types: Datetime 16
Data Types: Decimal 19
Datetime Conversions: DB2 21
Datetime Conversions: MySQL 24
Datetime Conversions: Oracle 28
Datetime Conversions: PostgreSQL 31
Datetime Conversions: SQL Server 34
Datetime Functions: DB2 38
Datetime Functions: MySQL 39
Datetime Functions: Oracle 40
Datetime Functions: PostgreSQL 43
Datetime Functions: SQL Server 45
v
Download from www.eBookTM.com
www.it-ebooks.info
Deleting Data 47
EXTRACT Function 51
GREATEST 52
Grouping and Summarizing 52
Hierarchical Queries 62
Indexes, Creating 66
Indexes, Removing 67
Inserting Data 67
Joining Tables 72
LEAST 82
Literals 82
Merging Data 86
Nulls 88
Numeric Conversions: DB2 93
Numeric Conversions: MySQL 95
Numeric Conversions: Oracle 95
Numeric Conversions: PostgreSQL 97
Numeric Conversions: SQL Server 98
Numeric/Math Functions 99
OLAP Functions 101
Pivoting and Unpivoting 101
Predicates 109
Recursive Queries 112
Regular Expressions 113
Selecting Data 124
String Functions 134
Subqueries 139
Tables, Creating 143
Tables, Dropping 148
Tables, Modifying 149
Transaction Management 154
Union Queries 162
vi | Table of Contents
Download from www.eBookTM.com
www.it-ebooks.info
Updating Data 168
Window Functions 173
Index 181
Table of Contents | vii
Download from www.eBookTM.com
www.it-ebooks.info
Download from www.eBookTM.com