SQL脚本 CASE......WHEN......THEN......ELSE......END 的应用
来源:互联网 发布:华为健康数据删除 编辑:程序博客网 时间:2024/05/16 04:57
--查找含有A 或 C 站点的车次
drop table SCHEDULETEST;
create table SCHEDULETEST
(
SID int not null,
CHECI VARCHAR(8),
CHEZHAN VARCHAR(8)
);
insert into SCHEDULETEST (SID, CHECI, CHEZHAN)
values (1, 'K1', 'A');
insert into SCHEDULETEST (SID, CHECI, CHEZHAN)
values (2, 'K1', 'B');
insert into SCHEDULETEST (SID, CHECI, CHEZHAN)
values (3, 'K1', 'C');
insert into SCHEDULETEST (SID, CHECI, CHEZHAN)
values (1, 'K1', 'A');
insert into SCHEDULETEST (SID, CHECI, CHEZHAN)
values (4, 'K2', 'A');
insert into SCHEDULETEST (SID, CHECI, CHEZHAN)
values (5, 'K2', 'B');
insert into SCHEDULETEST (SID, CHECI, CHEZHAN)
values (6, 'K2', 'C');
insert into SCHEDULETEST (SID, CHECI, CHEZHAN)
values (7, 'K3', 'D');
insert into SCHEDULETEST (SID, CHECI, CHEZHAN)
values (8, 'K4', 'D');
insert into SCHEDULETEST (SID, CHECI, CHEZHAN)
values (9, 'K5', 'D');
insert into SCHEDULETEST (SID, CHECI, CHEZHAN)
values (9, 'K5', 'C');
SELECT CHECI as '经过A和C站点的车次'
FROM SCHEDULETEST
WHERE CHEZHAN IN('A','C')
GROUP BY CHECI
HAVING COUNT(distinct SID)>=2;
SELECT CHECI
FROM SCHEDULETEST A
WHERE (CHEZHAN='A' OR CHEZHAN='C')
GROUP BY CHECI
HAVING COUNT(distinct SID)>=2;
--取出每一车次停靠的站点数
select checi '车次',count( distinct chezhan) AS '停靠站点数量'
from SCHEDULETEST
group by checi;
--取出每一车次停靠 A,C的站点次数
select checi AS 车次,
SUM(case chezhan when 'A' THEN 1 ELSE 0 END) '停靠A站点的次数',
SUM(case chezhan when 'C' THEN 1 ELSE 0 END) '停靠C站点的次数'
FROM SCHEDULETEST
GROUP BY CHECI;
- SQL脚本 CASE......WHEN......THEN......ELSE......END 的应用
- SQL脚本 CASE...WHEN...THEN...ELSE...END 的应用
- [ORACLE] case when then else end 应用
- [ORACLE] case when then else end 应用
- [ORACLE] case when then else end 应用
- [ORACLE] case when then else end 应用
- [ORACLE] case when then else end 应用
- sql case when then else end
- Sql语句-case when then else end
- sql case when then else end
- SQL的case when then else end语句的用法
- SQL的Case When ... Then ... Else ... End... 语句
- sql学习之CASE WHEN THEN ELSE END的用法
- case when then else end的用法
- case when then else end 的使用
- case when then else end
- case when then else end
- case when then else end
- MySQL ,MS SQL Server,类似功能的函数
- 由“标题”想开去
- 异步 Servlet 与 Comet 风格应用程序
- 深入解析C# 委托事件和Lambda表达式
- SVG
- SQL脚本 CASE......WHEN......THEN......ELSE......END 的应用
- 开发必读:如何成为一名优秀的Android开发者
- inf文件初探
- PB6.5导入Excel文件
- 宏定义有无参数宏定义和带参数宏定义两种
- 电容和电感充放电公式总结
- ie下载提示:无法下载,下载的站点不可用
- php 在数组中过虑重复
- Android GWES之Android窗口治理(转)