【入门】SQL1、查找最晚入职员工的所有信息

方一：排序

SELECT * FROM employees
ORDER BY hire_date DESC
LIMIT 0,1;

改进：

SELECT * FROM employees
WHERE hire_date = (
    SELECT hire_date FROM employees
    ORDER BY hire_date DESC
    LIMIT 1 OFFSET 0
);

方二：使用子查询

SELECT * FROM employees
WHERE hire_date =(
    SELECT MAX(hire_date)
     FROM employees
);