You will find many examples that address the complexity of language, along with key aspects of SQL that is 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. The third edition includes significant changes to the database, including: Oracle's support of recursive WITH syntax, and the addition function UNPIVOT PIVOT and new operators to Oracle, such as LISTAGG, NTH_VALUE, and more PostgreSQL support? of recursive WITH syntax window and some DB2 functions and datatypes, some compatible with features such as MySQL Oracle TIMESTAMP type and function TO_SECONDS