22,209
社区成员
发帖
与我相关
我的任务
分享怎样进行再次筛选
要按照GSH筛选出01的YUE 和xsje
查询结果如下：
select GSH,YUE,cast(xsje as decimal(10,2)) as xsje
from (select GSH,yue,SUM(XSJE)/10000000 as xsje from (
select GSH,DATEPART(MONTH,SWRQ) as yue,XSJE
from BBHLH
where SWRQ > = '2011/01/01'
and SWRQ < '2012/01/01') as tbl
group by GSH,yue) as tbl
order by GSH,yue
查询结果如下：
...全文
请发表友善的回复…
发表回复
飞翔羽翼 2013-07-02
- 打赏
- 举报
非常感谢~终于成功了
lzw_0736 2013-07-02
- 打赏
- 举报
select YUE,xsje
from
(
select GSH,YUE,cast(xsje as decimal(10,2)) as xsje
from
(
select GSH,yue,SUM(XSJE)/10000000 as xsje
from
(
select GSH,DATEPART(MONTH,SWRQ) as yue,XSJE
from BBHLH
where SWRQ > = '2011/01/01' and SWRQ < '2012/01/01'
) as tbl
group by GSH,yue
) as tbl
) as tb2
where GSH='01'
order by yue
