SQL袖珍参考手册 第3版，涵盖DB2，MySQL，Oracle，PostgreSQL，SQL Server英文pdf版
大小：960KB 时间：2024-12-07
《SQL袖珍参考手册(第3版，涵盖DB2，MySQL，Oracle，PostgreSQL，SQL Server)》(SQL Pocket Guide: A Guide to SQL Usage)英文文字版/更新源代码[PDF]
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
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
