[工学]s_chapter03.ppt

2003-3-14 Database Principles Programming Chapter 3Basic SQL Query Language Ch3 Basic SQL Query Language 3.1 Introduction 3.2 Setting Up the Database 3.3 Simple Select Statements 3.4 Subqueries 3.5 UNION Operators and FOR ALL Conditions 3.6 Some Advanced SQL Syntax 3.7 Set Functions in SQL 3.8 Groups of Rows in SQL 3.9 A Complete Description of SQL Select 3.10 Insert, Update, and Delete Statements 3.1 Introduction Structured Query Language – SQL including update, insert, delete operations SQL History 1976: SEQUEL (IBM, SYSTEM-R) 1979: SQL (Oracle公司，第一个商用版本) 1986: SQL-86 (ANSI) 1989: SQL-