ORACLE HAVING
来源:互联网 发布:greg laswell 知乎 编辑:程序博客网 时间:2024/06/06 17:38
在 SQL 中增加 HAVING 子句原因是,WHERE 关键字无法与合计函数一起使用。
语法:
SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE column_name operator value
GROUP BY column_name
HAVING aggregate_function(column_name) operator value
例子1:查找订单总金额少于 2000 的客户
SELECT Customer,SUM(OrderPrice) FROM Orders
GROUP BY Customer
HAVING SUM(OrderPrice)<2000;
例子2:查找客户 "Bush" 或 "Adams" 拥有超过 1500 的订单总金额
SELECT Customer,SUM(OrderPrice) FROM Orders
WHERE Customer='Bush' OR Customer='Adams'
GROUP BY Customer
HAVING SUM(OrderPrice)>1500;
4 0
- oracle having
- ORACLE HAVING
- Oracle HAVING子句
- oracle having用法
- Oracle HAVING子句
- oracle中的having子句
- oracle-where和having
- ORACLE命令 group by having
- oracle group by having 理解
- Oracle学习笔记(decode,Having)
- having
- having
- having
- Having
- having
- oracle where 和having从句区别
- Oracle SQL Having Where Group by
- 使用 HAVING 子句选择行 ORACLE
- qt与c的几种数据类型转换
- css3动画-00通俗易懂的介绍,你不能错过
- android studio 上配置opencv4Android
- Source Insight自定义快捷键
- LVM使用手册简化命令
- ORACLE HAVING
- TCP/IP 详解卷一 - TCP
- 使用 VMware 虚拟机的克隆功能,快速复制已安装好的 Linux 系统。|| ifconfig显示的IP和eth0的IP不一致
- nyoj题目101:两点距离
- 用 const 限定类的成员函数
- oracle-基于oracle dataguard滚动升级(oracle10.2.0.1--10.2.0.4--11.2.0.4)
- ORACLE GROUP BY
- GDAL 地理坐标与图像行列坐标之间相互转换公式
- 如何删除mysql服务