select *
from (SELECT COUNT (*),'FTTH' AS FTTH
FROM TAR_STATION T
WHERE FLDEX29 LIKE '%5%') P Natural
JOIN (SELECT COUNT(FLDID) AS 商务楼宇, 'FTTH' FTTH
FROM TAR_STATION A
WHERE A.FLDISFILLING = '1'
AND A.FLDBUILDSTATUS NOT IN ('3', '5')
AND A.FLDEX29 IS NOT NULL
AND A.FLDEX29 LIKE '%5%'
AND A.FLDEX68 = '1') Q Natural
JOIN (SELECT COUNT(*) AS 工业园区, 'FTTH' FTTH
FROM TAR_STATION S
WHERE S.FLDISFILLING = '1'
AND S.FLDBUILDSTATUS NOT IN ('3', '5')
AND S.FLDEX29 IS NOT NULL
AND S.FLDEX29 LIKE '%5%'
AND S.FLDEX68 = '2') W Natural
JOIN (SELECT COUNT(*) AS 专业市场, 'FTTH' FTTH
FROM TAR_STATION D
WHERE D.FLDISFILLING = '1'
AND D.FLDBUILDSTATUS NOT IN ('3', '5')
AND D.FLDEX29 IS NOT NULL
AND D.FLDEX29 LIKE '%5%'
AND D.FLDEX68 = '3') E Natural
JOIN (SELECT COUNT(*) AS 商业街, 'FTTH' FTTH
FROM TAR_STATION D
WHERE D.FLDISFILLING = '1'
AND D.FLDBUILDSTATUS NOT IN ('3', '5')
AND D.FLDEX29 IS NOT NULL
AND D.FLDEX29 LIKE '%5%'
AND D.FLDEX68 = '4') O Natural
JOIN (SELECT COUNT(*) AS 单点客户, 'FTTH' FTTH
FROM TAR_STATION D
WHERE D.FLDISFILLING = '1'
AND D.FLDBUILDSTATUS NOT IN ('3', '5')
AND D.FLDEX29 IS NOT NULL
AND D.FLDEX29 LIKE '%5%'
AND D.FLDEX68 = '5') I Natural
JOIN (SELECT COUNT(*) AS 商住楼, 'FTTH' FTTH
FROM TAR_STATION D
WHERE D.FLDISFILLING = '1'
AND D.FLDBUILDSTATUS NOT IN ('3', '5')
AND D.FLDEX29 IS NOT NULL
AND D.FLDEX29 LIKE '%5%'
AND D.FLDEX68 = '6') U Natural
JOIN (SELECT COUNT(*) AS 小区, 'FTTH' FTTH
FROM TAR_STATION D
WHERE D.FLDISFILLING = '1'
AND D.FLDBUILDSTATUS NOT IN ('3', '5')
AND D.FLDEX29 IS NOT NULL
AND D.FLDEX29 LIKE '%5%'
AND D.FLDEX68 = '7') Y Natural
JOIN (SELECT COUNT(*) AS 行政村, 'FTTH' FTTH
FROM TAR_STATION D
WHERE D.FLDISFILLING = '1'
AND D.FLDBUILDSTATUS NOT IN ('3', '5')
AND D.FLDEX29 IS NOT NULL
AND D.FLDEX29 LIKE '%5%'
AND D.FLDEX68 = '8') L Natural
JOIN (SELECT COUNT(*) AS 单点住宅楼, 'FTTH' FTTH
FROM TAR_STATION D
WHERE D.FLDISFILLING = '1'
AND D.FLDBUILDSTATUS NOT IN ('3', '5')
AND D.FLDEX29 IS NOT NULL
AND D.FLDEX29 LIKE '%5%'
AND D.FLDEX68 = '9') K
Natural
JOIN (SELECT COUNT(FLDID) AS 商务楼宇, 'FTTH' FTTH
FROM TAR_STATION QW
WHERE QW.FLDISFILLING = '1'
AND QW.FLDBUILDSTATUS NOT IN ('3', '5')
AND QW.FLDEX29 IS NOT NULL
AND QW.FLDEX29 LIKE '%6%'
AND QW.FLDEX68 = '1') QQ Natural
JOIN (SELECT COUNT(FLDID) AS 商务楼宇, 'FTTH' FTTH
FROM TAR_STATION QE
WHERE QE.FLDISFILLING = '1'
AND QE.FLDBUILDSTATUS NOT IN ('3', '5')
AND QE.FLDEX29 IS NOT NULL
AND QE.FLDEX29 LIKE '%6%'
AND QE.FLDEX68 = '1') QR Natural
JOIN (SELECT COUNT(*) AS 工业园区, 'FTTH' FTTH
FROM TAR_STATION QY
WHERE QY.FLDISFILLING = '1'
AND QY.FLDBUILDSTATUS NOT IN ('3', '5')
AND QY.FLDEX29 IS NOT NULL
AND QY.FLDEX29 LIKE '%6%'
AND QY.FLDEX68 = '2') QUW Natural
JOIN (SELECT COUNT(*) AS 专业市场, 'FTTH' FTTH
FROM TAR_STATION LLK
WHERE LLK.FLDISFILLING = '1'
AND LLK.FLDBUILDSTATUS NOT IN ('3', '5')
AND LLK.FLDEX29 IS NOT NULL
AND LLK.FLDEX29 LIKE '%6%'
AND LLK.FLDEX68 = '3') QWE Natural
JOIN (SELECT COUNT(*) AS 商业街, 'FTTH' FTTH
FROM TAR_STATION KKU
WHERE KKU.FLDISFILLING = '1'
AND KKU.FLDBUILDSTATUS NOT IN ('3', '5')
AND KKU.FLDEX29 IS NOT NULL
AND KKU.FLDEX29 LIKE '%6%'
AND KKU.FLDEX68 = '4') QWER Natural
JOIN (SELECT COUNT(*) AS 单点客户, 'FTTH' FTTH
FROM TAR_STATION JJK
WHERE JJK.FLDISFILLING = '1'
AND JJK.FLDBUILDSTATUS NOT IN ('3', '5')
AND JJK.FLDEX29 IS NOT NULL
AND JJK.FLDEX29 LIKE '%6%'
AND JJK.FLDEX68 = '5') WSX Natural
JOIN (SELECT COUNT(*) AS 商住楼, 'FTTH' FTTH
FROM TAR_STATION PPO
WHERE PPO.FLDISFILLING = '1'
AND PPO.FLDBUILDSTATUS NOT IN ('3', '5')
AND PPO.FLDEX29 IS NOT NULL
AND PPO.FLDEX29 LIKE '%6%'
AND PPO.FLDEX68 = '6') QAS Natural
JOIN (SELECT COUNT(*) AS 小区, 'FTTH' FTTH
FROM TAR_STATION CCV
WHERE CCV.FLDISFILLING = '1'
AND CCV.FLDBUILDSTATUS NOT IN ('3', '5')
AND CCV.FLDEX29 IS NOT NULL
AND CCV.FLDEX29 LIKE '%6%'
AND CCV.FLDEX68 = '7') ASD Natural
JOIN (SELECT COUNT(*) AS 行政村, 'FTTH' FTTH
FROM TAR_STATION VVC
WHERE VVC.FLDISFILLING = '1'
AND VVC.FLDBUILDSTATUS NOT IN ('3', '5')
AND VVC.FLDEX29 IS NOT NULL
AND VVC.FLDEX29 LIKE '%6%'
AND VVC.FLDEX68 = '8') AAS Natural
JOIN (SELECT COUNT(*) AS 单点住宅楼, 'FTTH' FTTH
FROM TAR_STATION NBV
WHERE NBV.FLDISFILLING = '1'
AND NBV.FLDBUILDSTATUS NOT IN ('3', '5')
AND NBV.FLDEX29 IS NOT NULL
AND NBV.FLDEX29 LIKE '%6%'
AND NBV.FLDEX68 = '9') SSY
我想要的是下面的这种怎么弄啊 谢谢大师们了
from (SELECT COUNT (*),'FTTH' AS FTTH
FROM TAR_STATION T
WHERE FLDEX29 LIKE '%5%') P Natural
JOIN (SELECT COUNT(FLDID) AS 商务楼宇, 'FTTH' FTTH
FROM TAR_STATION A
WHERE A.FLDISFILLING = '1'
AND A.FLDBUILDSTATUS NOT IN ('3', '5')
AND A.FLDEX29 IS NOT NULL
AND A.FLDEX29 LIKE '%5%'
AND A.FLDEX68 = '1') Q Natural
JOIN (SELECT COUNT(*) AS 工业园区, 'FTTH' FTTH
FROM TAR_STATION S
WHERE S.FLDISFILLING = '1'
AND S.FLDBUILDSTATUS NOT IN ('3', '5')
AND S.FLDEX29 IS NOT NULL
AND S.FLDEX29 LIKE '%5%'
AND S.FLDEX68 = '2') W Natural
JOIN (SELECT COUNT(*) AS 专业市场, 'FTTH' FTTH
FROM TAR_STATION D
WHERE D.FLDISFILLING = '1'
AND D.FLDBUILDSTATUS NOT IN ('3', '5')
AND D.FLDEX29 IS NOT NULL
AND D.FLDEX29 LIKE '%5%'
AND D.FLDEX68 = '3') E Natural
JOIN (SELECT COUNT(*) AS 商业街, 'FTTH' FTTH
FROM TAR_STATION D
WHERE D.FLDISFILLING = '1'
AND D.FLDBUILDSTATUS NOT IN ('3', '5')
AND D.FLDEX29 IS NOT NULL
AND D.FLDEX29 LIKE '%5%'
AND D.FLDEX68 = '4') O Natural
JOIN (SELECT COUNT(*) AS 单点客户, 'FTTH' FTTH
FROM TAR_STATION D
WHERE D.FLDISFILLING = '1'
AND D.FLDBUILDSTATUS NOT IN ('3', '5')
AND D.FLDEX29 IS NOT NULL
AND D.FLDEX29 LIKE '%5%'
AND D.FLDEX68 = '5') I Natural
JOIN (SELECT COUNT(*) AS 商住楼, 'FTTH' FTTH
FROM TAR_STATION D
WHERE D.FLDISFILLING = '1'
AND D.FLDBUILDSTATUS NOT IN ('3', '5')
AND D.FLDEX29 IS NOT NULL
AND D.FLDEX29 LIKE '%5%'
AND D.FLDEX68 = '6') U Natural
JOIN (SELECT COUNT(*) AS 小区, 'FTTH' FTTH
FROM TAR_STATION D
WHERE D.FLDISFILLING = '1'
AND D.FLDBUILDSTATUS NOT IN ('3', '5')
AND D.FLDEX29 IS NOT NULL
AND D.FLDEX29 LIKE '%5%'
AND D.FLDEX68 = '7') Y Natural
JOIN (SELECT COUNT(*) AS 行政村, 'FTTH' FTTH
FROM TAR_STATION D
WHERE D.FLDISFILLING = '1'
AND D.FLDBUILDSTATUS NOT IN ('3', '5')
AND D.FLDEX29 IS NOT NULL
AND D.FLDEX29 LIKE '%5%'
AND D.FLDEX68 = '8') L Natural
JOIN (SELECT COUNT(*) AS 单点住宅楼, 'FTTH' FTTH
FROM TAR_STATION D
WHERE D.FLDISFILLING = '1'
AND D.FLDBUILDSTATUS NOT IN ('3', '5')
AND D.FLDEX29 IS NOT NULL
AND D.FLDEX29 LIKE '%5%'
AND D.FLDEX68 = '9') K
Natural
JOIN (SELECT COUNT(FLDID) AS 商务楼宇, 'FTTH' FTTH
FROM TAR_STATION QW
WHERE QW.FLDISFILLING = '1'
AND QW.FLDBUILDSTATUS NOT IN ('3', '5')
AND QW.FLDEX29 IS NOT NULL
AND QW.FLDEX29 LIKE '%6%'
AND QW.FLDEX68 = '1') QQ Natural
JOIN (SELECT COUNT(FLDID) AS 商务楼宇, 'FTTH' FTTH
FROM TAR_STATION QE
WHERE QE.FLDISFILLING = '1'
AND QE.FLDBUILDSTATUS NOT IN ('3', '5')
AND QE.FLDEX29 IS NOT NULL
AND QE.FLDEX29 LIKE '%6%'
AND QE.FLDEX68 = '1') QR Natural
JOIN (SELECT COUNT(*) AS 工业园区, 'FTTH' FTTH
FROM TAR_STATION QY
WHERE QY.FLDISFILLING = '1'
AND QY.FLDBUILDSTATUS NOT IN ('3', '5')
AND QY.FLDEX29 IS NOT NULL
AND QY.FLDEX29 LIKE '%6%'
AND QY.FLDEX68 = '2') QUW Natural
JOIN (SELECT COUNT(*) AS 专业市场, 'FTTH' FTTH
FROM TAR_STATION LLK
WHERE LLK.FLDISFILLING = '1'
AND LLK.FLDBUILDSTATUS NOT IN ('3', '5')
AND LLK.FLDEX29 IS NOT NULL
AND LLK.FLDEX29 LIKE '%6%'
AND LLK.FLDEX68 = '3') QWE Natural
JOIN (SELECT COUNT(*) AS 商业街, 'FTTH' FTTH
FROM TAR_STATION KKU
WHERE KKU.FLDISFILLING = '1'
AND KKU.FLDBUILDSTATUS NOT IN ('3', '5')
AND KKU.FLDEX29 IS NOT NULL
AND KKU.FLDEX29 LIKE '%6%'
AND KKU.FLDEX68 = '4') QWER Natural
JOIN (SELECT COUNT(*) AS 单点客户, 'FTTH' FTTH
FROM TAR_STATION JJK
WHERE JJK.FLDISFILLING = '1'
AND JJK.FLDBUILDSTATUS NOT IN ('3', '5')
AND JJK.FLDEX29 IS NOT NULL
AND JJK.FLDEX29 LIKE '%6%'
AND JJK.FLDEX68 = '5') WSX Natural
JOIN (SELECT COUNT(*) AS 商住楼, 'FTTH' FTTH
FROM TAR_STATION PPO
WHERE PPO.FLDISFILLING = '1'
AND PPO.FLDBUILDSTATUS NOT IN ('3', '5')
AND PPO.FLDEX29 IS NOT NULL
AND PPO.FLDEX29 LIKE '%6%'
AND PPO.FLDEX68 = '6') QAS Natural
JOIN (SELECT COUNT(*) AS 小区, 'FTTH' FTTH
FROM TAR_STATION CCV
WHERE CCV.FLDISFILLING = '1'
AND CCV.FLDBUILDSTATUS NOT IN ('3', '5')
AND CCV.FLDEX29 IS NOT NULL
AND CCV.FLDEX29 LIKE '%6%'
AND CCV.FLDEX68 = '7') ASD Natural
JOIN (SELECT COUNT(*) AS 行政村, 'FTTH' FTTH
FROM TAR_STATION VVC
WHERE VVC.FLDISFILLING = '1'
AND VVC.FLDBUILDSTATUS NOT IN ('3', '5')
AND VVC.FLDEX29 IS NOT NULL
AND VVC.FLDEX29 LIKE '%6%'
AND VVC.FLDEX68 = '8') AAS Natural
JOIN (SELECT COUNT(*) AS 单点住宅楼, 'FTTH' FTTH
FROM TAR_STATION NBV
WHERE NBV.FLDISFILLING = '1'
AND NBV.FLDBUILDSTATUS NOT IN ('3', '5')
AND NBV.FLDEX29 IS NOT NULL
AND NBV.FLDEX29 LIKE '%6%'
AND NBV.FLDEX68 = '9') SSY
我想要的是下面的这种怎么弄啊 谢谢大师们了
sum(case NBV.FLDEX68 when '2' then 1 else 0 end) d2,
sum(case NBV.FLDEX68 when '3' then 1 else 0 end) d3,
sum(case NBV.FLDEX68 when '4' then 1 else 0 end) d4,
sum(case NBV.FLDEX68 when '5' then 1 else 0 end) d5,
sum(case NBV.FLDEX68 when '6' then 1 else 0 end) d6,
sum(case NBV.FLDEX68 when '7' then 1 else 0 end) d7,
sum(case NBV.FLDEX68 when '8' then 1 else 0 end) d8,
sum(case NBV.FLDEX68 when '9' then 1 else 0 end) d9,
'FTTH' FTTH
FROM TAR_STATION NBV
WHERE NBV.FLDISFILLING = '1'
AND NBV.FLDBUILDSTATUS NOT IN ('3', '5')
AND NBV.FLDEX29 IS NOT NULL
AND NBV.FLDEX29 LIKE '%6%'
1.商务楼宇2.工业园区3.专业市场4.商业街5.单点客户6.商住楼7.小区8.行政村9.单点住宅楼
第一列 第二例 第三例 第四列 第五列 第六列 第七列 第八咧 第九咧
1.包含楼宇专线 117 16 2 6 341 34 110 2 9
2.包含FTTH 410 452 49 41 4888 422 53538 883 6985
3.包含FTTB 148 197 9 7 610 59 4034 10 244