第2章 Transact-SQL语言 SELECT子句的语法形式如下所示: SELEC DTST工Ncr [roPn[ PERCEN][W工THT工ES] <se1ec七1ist> select list table name view name I 七ab1 e alias I column name expression 工DENT工 YCOL| ROWGUIDCOL 上一页 [I As 1 column alias column alias expression 下一页 逻回首上一页 下一页 返回首页 第2章 Transact-SQL语言 SELECT子句的语法形式如下所示： SELECT [ ALL | DISTINCT ] [ TOP n [ PERCENT ] [ WITH TIES ] ] < select_list > < select_list > ::= { * | { table_name | view_name | table_alias }.* | { column_name | expression | IDENTITYCOL | ROWGUIDCOL } [ [ AS ] column_alias ] | column_alias = expression } [ ,...n ]