select * from employees where right(emp_no,1) in ('1','3','5','7','9') and last_name<>'Mary' order by hire_date desc
可能并不简洁,但能解决实际问题
select * from employees where right(emp_no,1) in ('1','3','5','7','9') and last_name<>'Mary' order by hire_date desc
可能并不简洁,但能解决实际问题