原始查询:
SELECT * FROM ( SELECT employee_id, SUM(salary) AS total_salary FROM employee GROUP BY employee_id ) temp WHERE total_salary > 50000;
改写后的查询:
SELECT employee_id, SUM(salary) AS total_salary FROM employee GROUP BY employee_id HAVING total_salary > 50000;
上一篇:不使用临时表格重写查询