解题思路
奇数写法:n%2=1 n除于2余数为1,则为奇数
偶数写法:n%2=0 n除以2余数为0,则为偶数
SELECT * FROM employees AS e WHERE emp_no % 2=1 AND e.last_name != 'Mary' ORDER BY hire_date DESC;
解题思路
奇数写法:n%2=1 n除于2余数为1,则为奇数
偶数写法:n%2=0 n除以2余数为0,则为偶数
SELECT * FROM employees AS e WHERE emp_no % 2=1 AND e.last_name != 'Mary' ORDER BY hire_date DESC;