SQL袖珍参考手册(第3版)

中文名: SQL袖珍参考手册(第3版，涵盖DB2，MySQL，Oracle，PostgreSQL，SQL Server) 原名: SQL Pocket Guide: A Guide to SQL Usage 作者: Jonathan Gennick 资源格式: PDF 版本: 英文文字版/更新源代码 出版社: O'Reilly书号: 978-1-4493-9409-7发行时间: 2010年11月 地区: 美国 语言: 英文 简介: 内容介绍： If you're a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. You'll find many examples that address the language's complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1, Oracle Database 11g Release 2, PostgreSQL 9.0, and Microsoft SQL Server 2008 Release 2. All example SQL statements in this book execute against a set of tables, with data that you can quickly download. The third edition covers important database changes, including: Oracle's support of the recursive WITH syntax, and addition of PIVOT and UNPIVOT operators Functions new to Oracle, such as LISTAGG, NTH_VALUE, and more PostgreSQL’s support of recursive WITH and some window functions DB2 syntax and datatypes, some compatible with Oracle MySQL features such as the TIMESTAMP type and the TO_SECONDS function 目录: Introduction Analytic Functions CASE Expressions: Simple CASE Expressions: Searched CAST Function CONNECT BY Queries Data Type Conversion Data Types: Binary Integer Data Types: Character String Data Types: Datetime Data Types: Decimal Datetime Conversions: DB2 Datetime Conversions: MySQL Datetime Conversions: Oracle Datetime Conversions: PostgreSQL Datetime Conversions: SQL Server Datetime Functions: DB2 Datetime Functions: MySQL Datetime Functions: Oracle Datetime Functions: PostgreSQL Datetime Functions: SQL Server Deleting Data EXTRACT Function GREATEST Grouping and Summarizing Hierarchical Queries Indexes, Creating Indexes, Removing Inserting Data Joining Tables LEAST Literals Merging Data Nulls Numeric Conversions: DB2 Numeric Conversions: MySQL Numeric Conversions: Oracle Numeric Conversions: PostgreSQL Numeric Conversions: SQL Server Numeric/Math Functions OLAP Functions Pivoting and Unpivoting Predicates Recursive Queries Regular Expressions Selecting Data String Functions Subqueries Tables, Creating Tables, Dropping Tables, Modifying Transaction Management Union Queries Updating Data Window Functions