求一sql语句,查询同一xm 的记录合计数超过je 400.00的记录 多谢xm je rq
-- ---- ----------
a 200.00 2009-08-01
b 300.00 2009-08-02
a 110.00 2009-08-03
a 140.00 2009-08-04
c 450.00 2009-08-02要求结果
xm je
-- --
a 450.00
c 450.00
-- ---- ----------
a 200.00 2009-08-01
b 300.00 2009-08-02
a 110.00 2009-08-03
a 140.00 2009-08-04
c 450.00 2009-08-02要求结果
xm je
-- --
a 450.00
c 450.00
from tb
group by xm
having sum(je)>400.00
from tb
group by xm with rollup
having sum(je)>400.00 --合计与小计
from tb
group by xm
having sum(je)>400.00
很明显的group by跟having连用问题
select xm,sum(je)as je from TB group by xm having sum(je)>400
select xm,sum(je)as je from TB group by xm having sum(je)>400
from tb
group by xm
having sum(je)>400.00
小菜提问:这个约束根据什么来,我看不出来,为什么不是having sum(je)>300.00或者是在300---450之间的任何一个数呢?