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 n5.2 使用SELECT语句查询数据 5.2.1 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 ] 基本格式