mysql刷题1
nexthexonextbutterflyvolantisyearnyiliashokaindigoapollolandscapecactusmateryicarusfluidmaterial
查找最晚入职员工的所有信息查找最晚入职员工的所有信息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));
我们排序以后选出最大的
123select * from employees order by hire_date desc limit 0,1
找到最大值以后使用where
12select * from employees where hire_date = (select max(hire_date) from employees);
阅读全文…