1.说明&解释:
- 在limit后面添加的第一个数字m代表显示结果集中的前m行,第二个数字n则代表的是从m+1行开始数n行进行显示
2.代码:
SELECT * FROM employees
WHERE hire_date=(SELECT distinct hire_date FROM employees group by hire_date ORDER BY hire_date DESC LIMIT 2,1)
3.运行结果:
1.说明&解释:
2.代码:
SELECT * FROM employees
WHERE hire_date=(SELECT distinct hire_date FROM employees group by hire_date ORDER BY hire_date DESC LIMIT 2,1)
3.运行结果: