Loading

SQL15 查找employees表emp_no与last_name的员工信息

https://www.nowcoder.com/practice/a32669eb1d1740e785f105fa22741d5c?tpId=82&tags=&title=&difficulty=0&judgeStatus=0&rp=1

SELECT * 
FROM employees
WHERE emp_no % 2 = 1
AND last_name != 'Mary'
ORDER BY hire_date DESC;

posted @ 2022-01-09 10:22  Zhbeii  阅读(49)  评论(0)    收藏  举报