第5章表中数据的操作 51在企业管理器中操作表中的数据 52使用 SELECT语句査询数据 53使用 INSERT语句插入数据 54使用 UPDATE语句更新数据 55使用 DELETE语句删除数据
第5章 表中数据的操作 5.1 在企业管理器中操作表中的数据 5.2 使用SELECT语句查询数据 5.3 使用INSERT语句插入数据 5.4 使用UPDATE语句更新数据 5.5 使用DELETE语句删除数据
士 5,2使用 SELECT语句查询数据 SELECT语句的基本格式如下: SELECT select ist [INTO new table FROM table source I WHERE search condition I GROUP BY group by expression I HAVING search condition I ORDER BY order expression[ ASC L DESC]]
5.2 使用SELECT语句查询数据 SELECT语句的基本格式如下: SELECT select_list [ INTO new_table ] FROM table_source [ WHERE search_condition ] [ GROUP BY group_by_expression ] [ HAVING search_condition ] [ ORDER BY order_expression [ ASC | DESC ] ]
5,2使用 SELECT语句查询数据 521 SELECT子句 SELECT I ALL I DISTINCT I I TOP n PERCENT I[ WITH TIES ] select list select ist>日= Ii table name view_ name I table alias x column name expression IDENTITYCOL I ROWGUIDCOL y [[AS I column alias 1 基本格式 I column_alias expression n
5.2 使用SELECT语句查询数据 5.2.1 SELECT子句 SELECT [ ALL | DISTINCT ] [ TOP n [ PERCENT ] [ WITH TIES ] ] ::= { * | { table_name | view_name | table_alias }. * | { column_name | expression | IDENTITYCOL | ROWGUIDCOL } [ [ AS ] column_alias ] | column_alias = expression } [ ,...n ] 基本格式
5,2使用 SELECT语句查询数据 522INTo子句 IINTO new table 基本格式
5.2 使用SELECT语句查询数据 5.2.2 INTO子句 [ INTO new_table ] 基本格式
5,2使用 SELECT语句查询数据 523FRoM子句 I FROMi table source >In] table source >1= table name[[ as] table alias ][ WIth ( table_ hint >[un ])I view name[[ as i table alias I rowset function [ as table alias I OPENXML I derived table As table alias I column_ alias ln I< joined _table
5.2 使用SELECT语句查询数据 5.2.3 FROM子句 [ FROM { } [ ,...n ] ] ::= table_name [ [ AS ] table_alias ] [ WITH ( [ ,...n ] ) ] | view_name [ [ AS ] table_alias ] | rowset_function [ [ AS ] table_alias ] | OPENXML | derived_table [ AS ] table_alias [ ( column_alias [ ,...n ] ) ] |
5,2使用 SELECT语句查询数据 joined_table >i:= table_ source> on table source CRoSS JoIN table source joined _table ≤join_type>:= I INNERi LEFT RIGHT FULL 1 [ OUTER]了] [] 基本格式 JOIN
5.2 使用SELECT语句查询数据 ::= ON | CROSS JOIN | ::= [ INNER | { { LEFT | RIGHT | FULL } [OUTER] } ] [ ] JOIN 基本格式
5,2使用 SELECT语句查询数据 524 WHERE子句 WHERE search condition old outer join search condition >ii= [NOT]≤ predicate>|( searth_condition>)3 [{AND丨OR}[NoT] predicate >()31 ■■
5.2 使用SELECT语句查询数据 5.2.4 WHERE子句 WHERE | ::= { [ NOT ] | ( ) } [ { AND | OR } [ NOT ] { |( ) } ] } [ ,...n ]