查employees表empno与lastname的员工信息
查找employees表emp_no与last_name的员工信息
https://www.nowcoder.com/practice/a32669eb1d1740e785f105fa22741d5c
select * from employees where mod(emp_no,2)=1 and last_name!='mary' order by hire_date desc
求余数mod(被除数,除数)
查找employees表emp_no与last_name的员工信息
https://www.nowcoder.com/practice/a32669eb1d1740e785f105fa22741d5c
select * from employees where mod(emp_no,2)=1 and last_name!='mary' order by hire_date desc
求余数mod(被除数,除数)
相关推荐