查找入职员工时间排名倒数第三的员工所有信息
CREATE TABLE employees
(emp_no
int(11) NOT NULL,birth_date
date NOT NULL,first_name
varchar(14) NOT NULL,last_name
varchar(16) NOT NULL,gender
char(1) NOT NULL,hire_date
date NOT NULL,
PRIMARY KEY (emp_no
));
答案:
select * from employees order by hire_date desc limit 2, 1;
Original: https://www.cnblogs.com/sinodragon21/p/12668246.html
Author: sinodragon21
Title: SQL实战——02. 查找入职员工时间排名倒数第三的员工所有信息
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/610132/
转载文章受原作者版权保护。转载请注明原作者出处!