当前位置：首页 -> 基础 -> 数据库编程

Oracle 11g: The difference between WHERE and HAVING(二)

2014-11-24 08:24:04 · 作者: · 浏览: 10
标签: Oracle 11g: The difference between WHERE and HAVING
14
Suite Royal 10


There is no way to filter out sum(GUESTS)>8 entries using WHERE, because it doesn't allow to use Aggregate function in WHERE clause.

摘自 叶现一的专栏Coding