阅读背景:

有多个where子句的select查询在一个结果表中返回多个结果行吗?

来源:互联网 

I have a query such as:

我有一个查询,如:

SELECT COUNT(id) AS user_list FROM tbl_users
WHERE (enrolled = 1 AND age >=15 AND age < 20)
OR (enrolled = 1 AND age >=20 AND age < 25)
OR (enrolled = 1 AND age >=25 AND age < 30)
OR (enrolled = 1 AND age >=30)
SELECT CO



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: