34,837
社区成员




having sum(je)>400.00
having sum(je)>300.00
或者是在300---450之间的任何一个数呢?
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
select xm,sum(je) from tb group by xm having sum(je)>400.00