# 不相等有三种表示方式:<>、!=、IS NOT
select *
from employees
where emp_no%2 = 1 and last_name != 'Mary'
order by hire_date desc
# # 法二:使用&
# SELECT *
# FROM employees
# WHERE emp_no & 1 #通过二进制方式,&字符判断奇偶
# # WHERE emp_no%2 <> 0
# AND last_name<>'Mary'
# ORDER BY hire_date DESC;