SELECT主要子句 SELECT IALL I DISTINCT I [TOP expression [PERCENT] WITH TIES JI select list I INTO new table I FROM <table source>][,n11 WHERE <search condition> I GROUP BY [ALL I group by_ expression [,nI WITHI CUBE ROLLUP) I HAVING search condition >1 ORDER BY order expression [ASCDESC]] I COMPUTE IAVGICOUNTIMAXIMINSUMI (expression)][ .] BY expression [.n1I SQL SERVER2005入门与实例教程电子工业出版社2006SELECT 主要子句 SELECT [ ALL | DISTINCT ] [TOP expression [PERCENT] [WITH TIES ]] < select_list > [ INTO new_table ] [ FROM { <table_source> } [ ,...n ] ] [ WHERE <search_condition> ] [ GROUP BY [ ALL ] group_by_expression [ ,...n ] [ WITH { CUBE | ROLLUP } ] [ HAVING < search_condition > ] [ORDER BY order_expression [ASC|DESC]] [ COMPUTE {{AVG|COUNT|MAX|MIN|SUM} (expression)} [ ,...n ] [ BY expression [ ,...n ] ]