limit m,n
跳过m条数据,取n行数据
牛客网例题17: 获取当前薪水第二多的员工的emp_no以及其对应的薪水salary
select emp_no, salary
from salaries
where salary = (select salary from salaries order by salary desc limit 1,1)
2022-07-10 08:00:46
limit m,n
跳过m条数据,取n行数据
牛客网例题17: 获取当前薪水第二多的员工的emp_no以及其对应的薪水salary
select emp_no, salary
from salaries
where salary = (select salary from salaries order by salary desc limit 1,1)
下一篇:BUUCTF逆向题刷题记录(一)