15.查找employee表
题目内容:
代码及思路:
题目要求:1.emp_no为奇数;2.last_name不为Mary;3.hire_date逆序(大到小)
1.emp_no%2=1
2.last_name!='Mary
3.ORDER BY默认是从小到大
SELECT *
FROM employees
WHERE emp_no%2=1
AND last_name!='Mary'
ORDER BY hire_date DESC ;
15.查找employee表
题目内容:
代码及思路:
题目要求:1.emp_no为奇数;2.last_name不为Mary;3.hire_date逆序(大到小)
1.emp_no%2=1
2.last_name!='Mary
3.ORDER BY默认是从小到大
SELECT *
FROM employees
WHERE emp_no%2=1
AND last_name!='Mary'
ORDER BY hire_date DESC ;