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]]

 

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

posted @ 2019-01-20 22:07  MyPinky  阅读(563)  评论(0编辑  收藏  举报