day 1. 题目:展示最晚入职员工的所有信息(入职日期字段:hire_date)答案一:select * from employesorder by hire_date desc limit 1答案二:select * from employeswhere hire_date=(select max(hire_date) from employes)知识点:1.order by 列名 asc/desc--asc是升序,desc是降序,其中asc默认可省略2.limit a,b--a是起始格数-1,b是总个数2.利用排序查找:select * from 表 order by limit 0,54.where 后面要加表达式 用=号