解题思路
解法1:LIMIT m,n 函数 --跳过m条数据,取n行数据
SELECT emp_no,salary FROM salaries ORDER BY salary DESC LIMIT 1,1;
解法2: limit m offset n 函数-- 跳过n行数据,取m行数据
SELECT emp_no,salary FROM salaries ORDER BY salary DESC LIMIT 1 offset 1;
解题思路
解法1:LIMIT m,n 函数 --跳过m条数据,取n行数据
SELECT emp_no,salary FROM salaries ORDER BY salary DESC LIMIT 1,1;
解法2: limit m offset n 函数-- 跳过n行数据,取m行数据
SELECT emp_no,salary FROM salaries ORDER BY salary DESC LIMIT 1 offset 1;