Grouping on Column Expressions
来源:互联网 发布:商品关键字的seo处理 编辑:程序博客网 时间:2024/05/21 17:07
select case mod(empno,2)
when 0 then 'EVEN '
else 'ODD '
end as empno
sum(msal)
from employees
group by mod(empno,2);
EMPNO SUM(MSAL)
----- ---------
EVEN 20225
ODD 8650
when 0 then 'EVEN '
else 'ODD '
end as empno
sum(msal)
from employees
group by mod(empno,2);
EMPNO SUM(MSAL)
----- ---------
EVEN 20225
ODD 8650
- Grouping on Column Expressions
- Sum data based on its grouping
- GROUPING
- grouping
- Grouping
- Grouping
- GROUPING
- GROUPING
- Custom label on SysTableLookup column
- Parse query on pointer column
- Expressions
- Expressions
- Expressions
- Python笔记-Grouping Records Together Based on a Field
- XQuery表达式之序列类型表达式(Expressions on SequenceTypes)
- Specify the column on one-to-many
- Ruby on rails 插件File-Column问题
- SQL Group by date on datetime column
- Struts2体系原理图
- Introduction to COM and COM+
- UITextField的圆角和常用样式
- hibernate批量删除
- PPT模板应用中修改模板
- Grouping on Column Expressions
- 训练集-weka转换-----项目保留版
- 分析busybox中init程序的运行过程
- HAVING Clause Without a Group Function
- 返回去掉最后两级目录的目录字符串
- android基础笔记1
- NSXMLParser具体解析xml的应用详解
- android json
- 用Qt开发简单的浏览器(一)