第八章select.pptVIP

Select 查询操作 8.1 Select 语句语法 SELECT statement ::=query_expression[ ORDER BY { order_by_expression | column_position [ ASC | DESC ] } [,...n] ][ COMPUTE { { AVG | COUNT | MAX | MIN | SUM } (expression) } [,...n][ BY expression [,...n] ] ][ FOR { BROWSE | XML { RAW | AUTO | EXPLICIT }[ , XMLDATA ][ , ELEMENTS ][ , BINARY base64 ] }[ OPTION (query_hint [,...n]) ]query expression ::={ query specification | (query expression) }[UNION [ALL] query specification | (query expression) [...n] ]query specification ::=SELECT [ ALL | DISTINCT ][ {TOP integer | TOP integer PERCENT} [ WITH TIES]