SQL server SELECT 语句的基本结构

SELECT select_list [INTO new_table]

[FROM table_source] [WHERE search_condition]

[GROUP BY GROUP_BY_expresion]

[HAVING search_condition]

[ORDER BY ORDER_expression [Asc|Desc]]

 

各个关键字顺序必须严格遵守