下面的SQL语句要求能够分离出:
SELECT SO_soid,SO_KHID,KH_MC,SUM(SO_ZJE)AS ZJE
FROM SO,
(select KH_KHID,KH_MC,SUM(KH_YE)AS YE
from KH where KH_KHID='001'
group by KH_KHID,KH_MC
Having SUM(KH_YE)<>0)BB
WHERE SO_KHID=BB.KH_KHID
GROUP BY SO_SOID,SO_KHID,KH_MC
HAVING SUM(SO_ZJE)>0
ORDER BY SO_SOID,SO_KHID
分解结果如下:
SELECT--FROM:SO_soid,SO_KHID,KH_MC,SUM(SO_ZJE)AS ZJE
表名部分: SO,
(select KH_KHID,KH_MC,SUM(KH_YE)AS YE
from KH where KH_KHID='001'
group by KH_KHID,KH_MC
Having SUM(KH_YE)<>0)BB
Where语句部分:SO_KHID=BB.KH_KHID
Group by:SO_SOID,SO_KHID,KH_MC
HAVING:SUM(SO_ZJE)>0
ORDER BY :SO_SOID,SO_KHID
SELECT SO_soid,SO_KHID,KH_MC,SUM(SO_ZJE)AS ZJE
FROM SO,
(select KH_KHID,KH_MC,SUM(KH_YE)AS YE
from KH where KH_KHID='001'
group by KH_KHID,KH_MC
Having SUM(KH_YE)<>0)BB
WHERE SO_KHID=BB.KH_KHID
GROUP BY SO_SOID,SO_KHID,KH_MC
HAVING SUM(SO_ZJE)>0
ORDER BY SO_SOID,SO_KHID
分解结果如下:
SELECT--FROM:SO_soid,SO_KHID,KH_MC,SUM(SO_ZJE)AS ZJE
表名部分: SO,
(select KH_KHID,KH_MC,SUM(KH_YE)AS YE
from KH where KH_KHID='001'
group by KH_KHID,KH_MC
Having SUM(KH_YE)<>0)BB
Where语句部分:SO_KHID=BB.KH_KHID
Group by:SO_SOID,SO_KHID,KH_MC
HAVING:SUM(SO_ZJE)>0
ORDER BY :SO_SOID,SO_KHID
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货