SQL-CASEWhen使用
来源:互联网 发布:越南象棋软件 编辑:程序博客网 时间:2024/05/18 11:48
SELECT industryname,domaintype
,COUNT(domaintype) AS buscount,t1.total
--,SUM(buscount) AS total
FROM (
select ii.industryname as industryname,ii.industryid,d.setup_date,--d.busdomain_id,
CASE mm.memberlevelid WHEN '1' THEN '个人圈'
ELSE '公司圈'
END AS domaintype
from emk_business_domain d,emk_business_member m,
EMK_MEMCO_MEMBERINFO mm,
EMK_BUSINESS_INDUSTRY i,industry ii
WHERE d.busdomain_id=m.busdomain_id
AND mm.memberid=m.memberid
AND i.busdomain_id=d.busdomain_id
AND ii.industryid=i.fir_industry
AND d.DISPLAY_FLAG='0'
AND d.del_tag<>'9'
AND m.STATE<>'4'
AND m.affiliation_tag='1'
) tt,(select count(industryname) as total,ii.industryname as t1_name
from emk_business_domain d,emk_business_member m,
EMK_MEMCO_MEMBERINFO mm,
EMK_BUSINESS_INDUSTRY i,industry ii
WHERE d.busdomain_id=m.busdomain_id
AND mm.memberid=m.memberid
AND i.busdomain_id=d.busdomain_id
AND ii.industryid=i.fir_industry
AND d.DISPLAY_FLAG='0'
AND d.del_tag<>'9'
AND m.STATE<>'4'
AND m.affiliation_tag='1'
group by industryname
) t1
where tt.industryname=t1.t1_name
GROUP BY industryname,domaintype,total
,COUNT(domaintype) AS buscount,t1.total
--,SUM(buscount) AS total
FROM (
select ii.industryname as industryname,ii.industryid,d.setup_date,--d.busdomain_id,
CASE mm.memberlevelid WHEN '1' THEN '个人圈'
ELSE '公司圈'
END AS domaintype
from emk_business_domain d,emk_business_member m,
EMK_MEMCO_MEMBERINFO mm,
EMK_BUSINESS_INDUSTRY i,industry ii
WHERE d.busdomain_id=m.busdomain_id
AND mm.memberid=m.memberid
AND i.busdomain_id=d.busdomain_id
AND ii.industryid=i.fir_industry
AND d.DISPLAY_FLAG='0'
AND d.del_tag<>'9'
AND m.STATE<>'4'
AND m.affiliation_tag='1'
) tt,(select count(industryname) as total,ii.industryname as t1_name
from emk_business_domain d,emk_business_member m,
EMK_MEMCO_MEMBERINFO mm,
EMK_BUSINESS_INDUSTRY i,industry ii
WHERE d.busdomain_id=m.busdomain_id
AND mm.memberid=m.memberid
AND i.busdomain_id=d.busdomain_id
AND ii.industryid=i.fir_industry
AND d.DISPLAY_FLAG='0'
AND d.del_tag<>'9'
AND m.STATE<>'4'
AND m.affiliation_tag='1'
group by industryname
) t1
where tt.industryname=t1.t1_name
GROUP BY industryname,domaintype,total
- SQL-CASEWhen使用
- 报表SQL:casewhen-decode 行转列
- 聚合(CaseWhen(聚合)) 解决方案
- decode和casewhen和or函数的用法
- 使用SQL生成SQL
- SQL使用
- SQL使用
- 使用sql生成sql脚本
- 使用sql 来生成sql
- SQL语句 使用...代替
- 如何使用SQL*Loader?
- SQL中游标的使用
- 多表關聯查詢, 使用sql鎖定單張表
- 使用Sql生成测试数据
- DataSet 使用 Sql語法
- SQL-PLUS使用大全
- SQL查询语句使用
- SQL使用技巧
- 对日期操作
- Windows下Openssl安装以及编程
- 关于GridView或DataList中命令按钮
- odp使用笔记
- C++/C代码审查表
- SQL-CASEWhen使用
- jar打包详解
- 加大oracle的连接数
- Linux以及各大发行版简介
- 微软宣布结盟高通 智能手机芯片将支持Windows
- 利用 IIS日志追查网站入侵者
- 保险英语术语
- JavaOne 2006 不容错过的十大看点
- 从头开始