SQL学习笔记一：sql执行顺序

1.七种join语句：详情

---

2.sql的书写顺序：

SELECT DISTINCT *
FROM mysql.tbl_dept dep
    INNER JOIN mysql.tbl_emp emp ON dep.id = emp.deptId
WHERE deptId < 3
GROUP BY emp.name
HAVING dep.locAdd = 11
ORDER BY dep.deptName
LIMIT 1;

3.sql的执行顺序：

1.FROM(LEFT_TABLE) –>
2.ON(JOIN_CONDITION) –>
3.(JOIN_TYPE)JOIN(RIGHT_TABLE) –>
4.WHERE(WHERE_CONDITION) –>
5.GROUP_BY –>
6.HAVING –>
7.SELECT –>
8.ORDER BY –>
9.DISTINCT –>
10.LIMIT

---

4.sql的执行顺序(图解)：