sql语句执行流程

2019-10-21  本文已影响0人  潦倒神仙
image.png
FROM <left_table>
ON <join_condition>
<join_type> JOIN <right_table>
WHERE <where_condition>
GROUP BY <group_by_list>
HAVING <having_condition>
SELECT 
DISTINCT <select_list>
ORDER BY <order_by_condition>
LIMIT <limit_number>
image.png

https://www.cnblogs.com/annsshadow/p/5037667.html

上一篇下一篇

猜你喜欢

热点阅读