WHERE 和 HAVING 和有什么不一样 [英] what's the difference between WHERE and HAVING
本文介绍了WHERE 和 HAVING 和有什么不一样的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
看起来WHERE 和HAVING 都有助于过滤行.我想知道我是否可以使用 WHERE ... AND 而不是 HAVING.
It looks like both WHERE and HAVING help filter rows. I wonder if, instead of having to HAVING, I can use WHERE ... AND.
我有点困惑.
感谢您的帮助
推荐答案
这篇精品文章中的解释和查询示例:Where Vs Have/Have 和 Where 子句之间的区别
Explanation and query samples in this fine article: Where Vs Having / Difference between having and Where clause
这篇关于WHERE 和 HAVING 和有什么不一样的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文