MYSQL网站制作之一个sql语句，包括有几近一切尺度查询语...

如IBM公司最近宣布让渠道合作伙伴分销其SaaS应用程序的新计划。微软认为MySQL学习教程是销售其云计算服务的重要组成部分。然而即使有这种趋势，DBaaS仍然不同于内部数据库，解决方案提供商必须认识到这一点;否则，他们不仅仅是丢失几个客户，而是要失去的更多。尺度|语法|语句
W_KMR01_11----KMM13BRCOPYWRITEBYLD2000/09/0715:30

SELECTDISTINCTSUBSTRING(KMM102.KMM102_BGT_TYPE,1,4)ASBGT_TYPE,
(CASESUBSTRING(KMM102.KMM102_BGT_TYPE,3,2)WHEN"09"THEN"1"WHEN"10"THEN"2"
WHEN"11"THEN"3"ELSE"9"END)ASBGT_CLASS,
SUBSTRING(KMM102.KMM102_BGT_TYPE,1,2)ASBGT_TEAM,

(ISNULL((SELECTSUBSTRING(KMC101.KMC101_NAME,CHARINDEX("-",KMC101.KMC101_NAME)+1,12)FROMKMC101
WHERE(KMC101.KMC101_TYPE="BUDGETCODE")
AND(KMC101.KMC101_CODE=SUBSTRING(KMM102.KMM102_BGT_TYPE,1,4)+"00")),""))ASBGT_NAME,

SUM(ISNULL(KMM101.KMM101_BGT_JAN,0))ASBGT_AMT01,
SUM(ISNULL(KMM101.KMM101_BGT_FEB,0))ASBGT_AMT02,
SUM(ISNULL(KMM101.KMM101_BGT_MAR,0))ASBGT_AMT03,
SUM(ISNULL(KMM101.KMM101_BGT_APR,0))ASBGT_AMT04,
SUM(ISNULL(KMM101.KMM101_BGT_MAY,0))ASBGT_AMT05,
SUM(ISNULL(KMM101.KMM101_BGT_JUN,0))ASBGT_AMT06,
SUM(ISNULL(KMM101.KMM101_BGT_JUL,0))ASBGT_AMT07,
SUM(ISNULL(KMM101.KMM101_BGT_AUG,0))ASBGT_AMT08,
SUM(ISNULL(KMM101.KMM101_BGT_SEP,0))ASBGT_AMT09,
SUM(ISNULL(KMM101.KMM101_BGT_OCT,0))ASBGT_AMT10,
SUM(ISNULL(KMM101.KMM101_BGT_NOV,0))ASBGT_AMT11,
SUM(ISNULL(KMM101.KMM101_BGT_DEC,0))ASBGT_AMT12,

(SUM(ISNULL(KMM101.KMM101_BGT_JAN,0))+SUM(ISNULL(KMM101.KMM101_BGT_FEB,0))+
SUM(ISNULL(KMM101.KMM101_BGT_MAR,0))+SUM(ISNULL(KMM101.KMM101_BGT_APR,0))+
SUM(ISNULL(KMM101.KMM101_BGT_MAY,0))+SUM(ISNULL(KMM101.KMM101_BGT_JUN,0))+
SUM(ISNULL(KMM101.KMM101_BGT_JUL,0))+SUM(ISNULL(KMM101.KMM101_BGT_AUG,0))+
SUM(ISNULL(KMM101.KMM101_BGT_SEP,0))+SUM(ISNULL(KMM101.KMM101_BGT_OCT,0))+
SUM(ISNULL(KMM101.KMM101_BGT_NOV,0))+SUM(ISNULL(KMM101.KMM101_BGT_DEC,0)))ASAMT01,
("XXXXXXXX")ASAMT02,

SUM(ISNULL((CASEWHEN(CONVERT(CHAR(8),KMM102.KMM102_CHK_DATE,112)<"YYYYMMDD")
THENKMM102.KMM102_CHK_AMTELSE0END),0))ASAMT09,
SUM(ISNULL((CASEWHEN((CONVERT(CHAR(8),KMM102.KMM102_OVER_DATE,112)<"YYYYMMDD")
ANDKMM102.KMM102_OVER_STATUS"00")
THENKMM102.KMM102_OVER_AMT
WHEN((CONVERT(CHAR(8),KMM102.KMM102_OVER_DATE,112)<"YYYYMMDD")
ANDKMM102.KMM102_OVER_STATUS="00")
THENKMM102.KMM102_OVER_AMTELSE0END),0))ASAMT07,
SUM(ISNULL((SELECTCASEWHEN((CONVERT(CHAR(8),KMM103.KMM103_PAY_DATE,112)<"YYYYMMDD")
ANDKMM103.KMM103_PAY_STATUS"2")
THENKMM103.KMM103_PAY_AMTELSE0END
FROMKMM103
WHERE(KMM103.KMM103_YY=KMM102.KMM102_YY)
AND(KMM103.KMM103_BGT_KIND=KMM102.KMM102_BGT_KIND)
AND(KMM103.KMM103_CASE_NO=KMM102.KMM102_CASE_NO)),0))ASAMT03,
SUM(ISNULL((SELECTCASEWHEN((CONVERT(CHAR(8),KMM103.KMM103_PAY_DATE,112)<"YYYYMMDD")
ANDKMM103.KMM103_PAY_STATUS"1")
THENKMM103.KMM103_PAY_AMTELSE0END
FROMKMM103
WHERE(KMM103.KMM103_YY=KMM102.KMM102_YY)
AND(KMM103.KMM103_BGT_KIND=KMM102.KMM102_BGT_KIND)
AND(KMM103.KMM103_CASE_NO=KMM102.KMM102_CASE_NO)),0))ASAMT04
FROMKMM102,
KMM101
WHERE(KMM102.KMM102_YY="YYY")AND
(KMM102.KMM102_BGT_KIND="1")AND
(KMM101.KMM101_YY=*KMM102.KMM102_YY)AND
(KMM101.KMM101_BGT_KIND=*KMM102.KMM102_BGT_KIND)AND
(KMM101.KMM101_BGT_TYPE=*KMM102.KMM102_BGT_TYPE)
GROUPBYSUBSTRING(KMM102.KMM102_BGT_TYPE,1,4),
SUBSTRING(KMM102.KMM102_BGT_TYPE,3,2),
SUBSTRING(KMM102.KMM102_BGT_TYPE,1,2)
ORDERBYBGT_CLASSASC,
BGT_TYPEDESC
;
人力成本上的节省，MySQL的用户Spacemonkey实验室的首席执行官MitchPirtle如此表示：“维护MySQL使得你不需要一个年薪15万美元的DBA。

外键的级联更能扩展可能大部分的同行在设计OLTP系统的时候都不愿意建立外键，都是通过程序来控制父子数据的完整性。