我查询我的MySQL“consumer_details”表，其中年龄> 30 purchase_count > 100，在同一时间，我需要排除的年龄的人谁是等号（=）50和purchase_count < 100
现在我运行下面的查询：
基本查询：
SELECT *
FROM `consumer_details`
WHERE `age` > 30 AND `purchase_count ` > 100
ORDER BY `gender` DESC
扩展查询：
SELECT *
FROM `consumer_details`
WHERE `age` > 30 AND `purchase_count ` > 100
NOT IN (`age` = 50 AND `purchase_count ` < 100 )
ORDER BY `gender` DESC
SELECT *
FROM consumer_details
WHERE (age > 30 AND purchase_count > 100)
AND NOT (age = 50 AND purchase_count < 100)
ORDER BY gender DESC
本文收集自互联网，转载请注明来源。
如有侵权，请联系 [email protected] 删除。
我来说两句