SELECT * FROM employees AS e WHERE e.hire_date = (SELECT distinct hire_date FROM employees ORDER BY hire_date desc limit 2,1); 和 SELECT * FROM employees ORDER BY hire_date desc limit 2,1 效果是一样的,为什么后者就不可以呢 orderBY 字句,LIMIT含义的理解
SELECT * FROM employees AS e WHERE e.hire_date = (SELECT distinct hire_date FROM employees ORDER BY hire_date desc limit 2,1); 和 SELECT * FROM employees ORDER BY hire_date desc limit 2,1 效果是一样的,为什么后者就不可以呢 orderBY 字句,LIMIT含义的理解