V2EX = way to explore V2EX 是一个关于分享和探索的地方
Sign Up Now For Existing Member Sign In
请不要在回答技术问题时复制粘贴 AI 生成的内容
This topic created in 4329 days ago, the information mentioned may be changed or developed.
SELECT *,一个表达式 AS flag FROM (这里2个表INNER JOIN) AS c
INNER JOIN 表D AS d
ON c.part = d.part HAVING flag='1'
现在having之后是2条结果，我直接用 select count(*) xxxx 结果是4，不准确。
INNER JOIN 表D AS d
ON c.part = d.part HAVING flag='1'
现在having之后是2条结果，我直接用 select count(*) xxxx 结果是4，不准确。
 | 1 hennywei Jun 20, 2014 group by 呢 |
 | 2 qq2511296 Jun 20, 2014 select count(t.*) from ( SELECT *,一个表达式 AS flag FROM (这里2个表INNER JOIN) AS c INNER JOIN 表D AS d ON c.part = d.part HAVING flag='1' ) t 楼主这样测试结果是4？ HAVING好像是最后才执行 一般都是放在group by 后面的 |
 | 4 F281M6Dh8DXpD1g2 Jun 20, 2014 没看懂什么意思,lz不妨贴个例子? |
Select Language