第8章 数据操作

第8章 数据操作

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

View Full Document Right Arrow Icon
第 8 第 第第第第 第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第 INSERT 第 UPDATE 第 DELETE 第第第第第第第第 DML 第第第第第第第 第第第第第第第第第第第第第第第第第第第第第第第第第第
Background image of page 1

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

View Full DocumentRight Arrow Icon
8.1 第 SELECT 第第第第第第 SELECT 第第第第第第 SQL 第第第第第第第第第第第第第第第 SELECT 第第第第第第第第第 第第第第第第第第第第第第第第第第第第第第第 SELECT select_list [ INTO new_table ] 第第第 [FROM table_source ] [ WHERE search_condition ] 第第第 [WITH <common_table_expression>] 第第第 [GROUP BY group_by_expression] 第第第 [HAVING search_condition] 第第第 [ORDER BY order_expression [ ASC | DESC ] ] 第第第
Background image of page 2
8.1.1 SELECT 第第 SELECT 第第第 FROM 第第第第 SELECT 第第第第第第第第第第第第第第第第第第第第 第第第
Background image of page 3

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

View Full DocumentRight Arrow Icon
8.1.2 FROM 第第 第 8.1.1 第第第第第 SELECT 第第第第 FROM 第第第第第第第第第第第第第第第第第第第第第 第第第第第第第 FROM 第第第第第第第 DELETE 第 SELECT 第 UPDATE 第第第第第第第第第第第第第第第第第第第
Background image of page 4
8.1.3 INTO 第第 INTO 第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第 第第第第第第第第第第第第第第第第第第第第
Background image of page 5

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

View Full DocumentRight Arrow Icon
8.1.4 WHERE 第第 WHERE 第第第第第第第第第第第第第第第第第第 WHERE 第第第第第第第第第第第第第第第第 -- 第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第 1 第 WHERE 第第第第第 2 第 <search_condition> 第第第第第第 3 第 <predicate> 第第第 4 第第第 LIKE 第第第第第 5 第第第 LIKE 第 ESCAPE 第第第第
Background image of page 6
8.1.5 ORDER BY 第第 ORDER BY 第第第第第 SELECT 第第第第第第第第第第第第第第 SELECT 第第第 第第第第第第第第第第 ORDER BY 第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第
Background image of page 7

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

View Full DocumentRight Arrow Icon
8.1.6 GROUP BY 第第 GROUP BY 第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第
Background image of page 8
8.1.7 HAVING 第第 HAVING 第第第第第 SELECT 第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第第 第第第第第第第 HAVING 第第第 GROUP BY 第第第第第第第第第第第 GROUP BY 第第第第 HAVING 第第第第 WHERE 第第第第第
Background image of page 9

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

View Full DocumentRight Arrow Icon
8.1.8 FOR 第第 FOR 第第第第第第 BROWSE 第 XML 第第第第第第第第第第第第第第第第第第第 FOR 第第第第 XML 第第第第第第第第第第第 24 第第第第第第第第第第 FOR 第第第第第第第第第第第第第第第第
Background image of page 10
8.1.9
Background image of page 11

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

View Full DocumentRight Arrow Icon
Image of page 12
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/23/2011 for the course CS SQL taught by Professor Li during the Spring '07 term at Fudan University.

Page1 / 44

第8章 数据操作

This preview shows document pages 1 - 12. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online