SQL语句的基本组成形式

SQL语句需要按照一定的顺序调用各种结构和关键词，如果顺序颠倒，则无法正常的编译通过，执行出正确的操作结果。

 

SQL语句的正确顺序：

#SQL语句的基本形式
SELECT AVG(salary),e.department_id,d.department_name
FROM employees e JOIN departments d
ON e.department_id = d.department_id
WHERE d.department_id = 50
GROUP BY department_id
HAVING AVG(salary) > 1000
ORDER BY AVG(salary) ASC
LIMIT 0,1;