MySQL 查询薪资大于15000或员工ID为1的员工 (互斥条件)

• 日期: 2028-07-03
• 标签: 常规

SELECT * FROM t_employee WHERE (salary > 15000 AND did != 1) OR (salary <= 15000 AND did = 1);

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

免费AI点我,无需注册和登录