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

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

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