SQL Pocket Guide

SQL Pocket Guide is the ultimate reference for programmers and database administrators who use SQL in their work. This pocket guide covers the language's complexity, with examples that illustrate the key aspects of SQL found in IBM DB2 Release 9.7, MySQL 5.1, Oracle Database 11g Release 2, PostgreSQL 9.0, and Microsoft SQL Server 2008 Release 2. The guide also explains how these database systems implement SQL syntax for querying, managing transactions, and making changes to data. It covers SQL functions, regular expression syntax and type conversion functions and formats. The third edition includes important database changes, including Oracle's new support of recursive WITH syntax and PostgreSQL's recursive WITH support and some window functions.