select cp,count(*) as cp from tkt where cp='3' gropy by cp
union all
select cp,count(*) from dxt where cp='3' gropy by cp
union all
select cp,count(*) from fxt where cp='3' gropy by cp
union all
select cp,count(*) from pdt where cp='3' gropy by cp
union all
select cp,count(*) from wdt where cp='3' gropy by cp
union all
select cp,count(*) from dxt where cp='3' gropy by cp
union all
select cp,count(*) from fxt where cp='3' gropy by cp
union all
select cp,count(*) from pdt where cp='3' gropy by cp
union all
select cp,count(*) from wdt where cp='3' gropy by cp
解决方案 »
- 您有一个系统中心配置管理器 2007年环境。您需要确保您能够使用配置管理器将自动安装到系统发现您的 Active Directory 域中的代理。您应执行哪些操
- 求一条SQL语句
- SQL2000中 grant create table on my_table to john 的john用户是怎样建立的
- 横列转换并加上【合计】,详细请进来...
- SQL日志,如何分析,帮我看看
- 如何获取SQLServer所在服务器的日期格式,如yyyy/mm/dd还是yyyy-mm-dd还是mm-dd-yyyy呢?
- 函数里执行EXEC,但是...在函数内不正确地使用了 'EXECUTE'.....????
- [SQL Sever 2005]安装之后,无法启动数据库服务器
- 报表查询的实现
- 送分!!!!打不开oracle数据库?
- 这样做为什么不行,要怎么做呢?关于sql语句的,在线
- 安装sqlserver标准版和企业版的时候,出现“无法装载....”
'DXTCount' = d.[count],
'FXTCount' = f.[count],
'PDTCount' = p.[count],
'WDTCount' = w.[count]
FROM (SELECT COUNT(*) AS [count] FROM TKT WHERE cp = '3' GROUP BY cp) t CROSS JOIN
(SELECT COUNT(*) AS [count] FROM DXT WHERE cp = '3' GROUP BY cp) d CROSS JOIN
(SELECT COUNT(*) AS [count] FROM FXT WHERE cp = '3' GROUP BY cp) f CROSS JOIN
(SELECT COUNT(*) AS [count] FROM PDT WHERE cp = '3' GROUP BY cp) p CROSS JOIN
(SELECT COUNT(*) AS [count] FROM WDT WHERE cp = '3' GROUP BY cp) w
(SELECT COUNT(*) FROM DXT WHERE CP = '3') AS DXTCOUNT,
(SELECT COUNT(*) FROM FXT WHERE CP = '3') AS FXTCOUNT,
(SELECT COUNT(*) FROM PXT WHERE CP = '3') AS PXTCOUNT,
(SELECT COUNT(*) FROM WXT WHERE CP = '3') AS WXTCOUNT