查询工资大于2000且非经理或文员的员工信息

SELECT * FROM employees WHERE job_title NOT IN ('MANAGER', 'CLERK') AND salary >= 2000;

原文地址: https://www.cveoy.top/t/topic/p5VN 著作权归作者所有。请勿转载和采集!