SUMdecodeTO_CHARatelfeedatemm01afactratio
ASJANSUMdecodeTO_CHARatelfeedatemm02afactratio
ASFRISUMdecodeTO_CHARatelfeedatemm03afactratio
ASMARSUMdecodeTO_CHARatelfeedatemm04afactratio
ASAPRSUMdecodeTO_CHARatelfeedatemm05afactratio
ASMAYSUMdecodeTO_CHARatelfeedatemm06afactratio
ASJUESUMdecodeTO_CHARatelfeedatemm07afactratio
ASJULSUMdecodeTO_CHARatelfeedatemm08afactratio
ASAGUSUMdecodeTO_CHARatelfeedatemm09afactratio
ASSEPSUMdecodeTO_CHARatelfeedatemm10afactratio
AS
fOCTSUMdecodeTO_CHARatelfeedatemm11afactratio
ASNOVSUMdecodeTO_CHARatelfeedatemm12afactratio
ASDECFROMSELECTauserperatelasta
dfeebtelfeedatebfactratio
FROMTELFEESTANDaTELFEEbWHEREatelbtelfaxaGROUPBYauserperatelasta
dfeeTO_CHARatelfeedateyyyy8说明：四表联查问题：SQLselectfromalefti
erjoi
bo
aabbrighti
erjoi
co
aacci
erjoi
do
aaddwhere9说明：得到表中最小的未使用的ID号SQLSELECTCASEWHENEXISTSSELECTFROMHa
dlebWHEREbHa
dleID1THENMINHa
dleID1ELSE1ENDasHa
dleIDFROMHa
dleWHERENOTHa
dleIDINSELECTaHa
dleID1FROMHa
dlea10说明：模糊查询，单字匹配短横线代表待匹配内容selectfromtablewherefield1likeA_B_C11说明：as的用法selectidcolum
1colum
2ascolum
fromtable1
fr