题目描述
获取当前(to_date=‘9999-01-01’)薪水第二多的员工的emp_no以及其对应的薪水salary
CREATE TABLE salaries
(
emp_no
int(11) NOT NULL,
salary
int(11) NOT NULL,
from_date
date NOT NULL,
to_date
date NOT NULL,
PRIMARY KEY (emp_no
,from_date
));
解析
首先是按薪水排序就行,然后取第二的值,然后日期是当前日期
select emp_no,salary from salaries where to_date='9999-01-01' order by salary desc limit 1,1