sql 中limit和offset
limitselect * from tableName limit i,ntableName 数据表i:为查询结果(默认从零开始)n:为返回的数量offset跳过几行元素牛客sql寻找倒数第三晚入职的员工select * from employeeswhere hire_date = ( select distinct hire_date from employees order by hire_date desc limit 1 offset 2
原创
2021-03-08 14:27:51 ·
117 阅读 ·
0 评论