T-SQL基本语句

基本的SELECT语句

• Select语句的基本语法规则

  SELECT [ALL|DISTINCT] [TOP (<expression>) [PERCENT] [WITH TIES]]
  FROM <source table(s)/view(s)>]
  [WHERE <restrictive condition>]
  [GROUP BY <column name or expression using a column in the SELECT list>]
  [HAVING <restrictive condition based on the GROUP BY results]
  [ORDER BY <column list>]
  [[FOR XML {RAW|AUTO|EXPLICIT|PATH [(<element>)]} [, XMLDATA]
                                [, ELEMENTS][, BINARY base 64]]
  [OPTION (<query hint>, [, ...n])]S