同样的SQL语句程序中和查询分析器中取出的记录数不一样???
语句如下:
SELECT CCLDXX.wzdm as wzdm,CCLDXX.wzxh,CCLDXX.wzgg,CCLDXX.sfdm,CCLDXX.hsxs,sum(CCLDXX.fssl * CCLDXX.jhdj)/10000 as xfl,0 as bchj,0 as bcjg,0 as bjjj,0 as zgsw,0 as pypk,0 as qmhj,0 as zykc,0 as jgkc,0 as yhhj From CCLDXX
Where
(
(CCLDXX.WZDM>='700000' AND CCLDXX.WZDM<='701403')
or (CCLDXX.WZDM>='701500' AND CCLDXX.WZDM<='701523')
or CCLDXX.wzdm='710101' or CCLDXX.wzdm='770105'
or (CCLDXX.WZDM>='720000' AND CCLDXX.WZDM<='739999')
or substring(CCLDXX.wzdm,1,4)='7802' or CCLDXX.wzdm='770101' or CCLDXX.wzdm='760201' or CCLDXX.wzdm='281517'
or CCLDXX.wzdm='281521' or CCLDXX.wzdm='770213' or CCLDXX.wzdm='770201' or CCLDXX.wzdm='770209'
or CCLDXX.wzdm='770205' or Substring(CCLDXX.wzdm,1,4)='7703'
)
and substring(CCLDXX.zkhm,1,2) <>'13'
and ((CCLDXX.sfdm >='31' and CCLDXX.sfdm<='50') or CCLDXX.sfdm in ('74','76'))
and (Left(CCLDXX.ckrq,6)>='200404' and Left(CCLDXX.ckrq,6)<='200405')
Group by CCLDXX.wzdm,CCLDXX.wzxh,CCLDXX.wzgg,CCLDXX.sfdm,CCLDXX.hsxs
order by CCLDXX.wzdm,CCLDXX.wzxh,CCLDXX.wzgg,CCLDXX.sfdm,CCLDXX.hsxs