{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

ch3 - Chapter 3 SQL Chapter Database System Concepts 5th Ed...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
Database System Concepts, 5th Ed . ©Silberschatz, Korth and Sudarshan See www.db-book.com for conditions on re-use Chapter 3: SQL Chapter 3: SQL
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
©Silberschatz, Korth and Sudarshan 3.2 Database System Concepts, 5 th Edition, Oct 5, 2006 Chapter 3: SQL Chapter 3: SQL Data Definition Basic Query Structure Set Operations Aggregate Functions Null Values Nested Subqueries Complex Queries Views Modification of the Database Joined Relations**
Background image of page 2
©Silberschatz, Korth and Sudarshan 3.3 Database System Concepts, 5 th Edition, Oct 5, 2006 History History IBM Sequel language developed as part of System R project at the IBM San Jose Research Laboratory Renamed Structured Query Language (SQL) ANSI and ISO standard SQL: z SQL-86 z SQL-89 z SQL-92 z SQL:1999 (language name became Y2K compliant!) z SQL:2003 Commercial systems offer most, if not all, SQL-92 features, plus varying feature sets from later standards and special proprietary features. z Not all examples here may work on your particular system.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon