MySQL中limit 和offset 的区别

 selete * from testtable limit 2,1;

 selete * from testtable limit 2 offset 1;

数据库数据计算是从0开始的
limit 2,1表示从表testtable中第三条开始查询，取一条数据，即第三条数据读取，跳过第一二条后,取一条数据
limit 2 offset 1表示从数据库中的第二条数据开始查询两条数据，即第二条和第三条
跳过前1条后，取接下来的两条数据

怀疑上述是错误的，因此看下题

LeetCode—求第二高薪水

问题描述：

结果一致，时间复杂度不同

select max(salary) as SecondHighestSalary from Employee where salary < (select max(salary) from Employee)

select IFNULL((select distinct  salary  from Employee order by Salary desc limit 1 , 1),NULL) AS SecondHighestSalary;

select IFNULL((select distinct  salary  from Employee order by Salary desc limit 1 offset 1),NULL) AS SecondHighestSalary;

LeetCode—查询第n高薪水