SQL执行顺序

作者: 叨叨侠爱叨叨 | 来源:发表于2017-10-26 17:10 被阅读5次
(8)SELECT (9)DISTINCT  (11)<Top Num> <select list>
(1)FROM [left_table]
(3)<join_type> JOIN <right_table>
(2)        ON <join_condition>
(4)WHERE <where_condition>
(5)GROUP BY <group_by_list>
(6)WITH <CUBE | RollUP>
(7)HAVING <having_condition>
(10)ORDER BY <order_by_list>

相关文章

网友评论

    本文标题:SQL执行顺序

    本文链接:https://www.haomeiwen.com/subject/jivkpxtx.html