Ebook: SQL in a Nutshell

The essential reference to the SQL language used in today's most popular database products, this new edition of SQL in a Nutshell clearly documents every SQL command according to the latest ANSI standard. It also details how these commands are implemented in the Microsoft SQL Server 2008 and Oracle 11g commercial database packages, and the MySQL 5.1 and PostgreSQL 8.3 open source database products.;SQL in a Nutshell; Who Should Read This Book?; How This Book Is Organized; How to Use This Book; Resources; Changes in the Third Edition; Conventions Used in This Book; Using Code Examples; How to Contact Us; Safari® Books Online; Acknowledgments; Daniel Kline & s Acknowledgments; Brand Hunt & s Acknowledgments; 1. SQL History and Implementations; NULLs (rule 3); Metadata (rules 4 and 10); The language (rules 5 and 11); Views (rule 6); Set operations (rules 7 and 12); Codd & s Rules in Action: Simple SELECT Examples; History of the SQL Standard; What & s New in SQL2003 (SQL3); Levels of Conformance.