题解 | 查找employees表emp_no与last_name的员工信息
查找employees表emp_no与last_name的员工信息
https://www.nowcoder.com/practice/a32669eb1d1740e785f105fa22741d5c
SELECT
*
from
employees
where
last_name != 'Mary'
and MOD(emp_no, 2) = 1
-- or (emp_no % 2 = 1)
order by
hire_date desc;
SELECT
*
from
employees
where
last_name != 'Mary'
and emp_no & 1 = 1
order by
hire_date desc;
查看2道真题和解析