SQL袖珍参考手册 第3版

【实例截图】

【核心代码】

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
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
Updating Data 168
Window Functions 173
Index 181