For programmers & database administrators who use SQL in their day-to-day work this popular pocket guide is the ideal on-the-job reference. It uses numerous examples to address the languages complexity & covers key aspects of SQL used in Oracle DB2 SQL Server My SQL & Postgre SQL. That
Includes:: the syntax for querying managing transactions & making changes to data as well as SQL functions type conversion functions & formats & regular expression syntax. The third edition covers important database changes including: * Oracles support of the recursive WITH syntax & addition of PIVOT & UNPIVOT operators * Functions new to Oracle such as LISTAGG NTH_VALUE & more * Postgre SQLs support of recursive WITH & some window functions * DB2 syntax & datatypes some for compatibility with Oracle * My SQL features such as the TIMESTAMP type & the TO_SECONDS function