Question

mysql查询语句

select username,sum(jf) from a_log where addtime between date('2013-9-1') and date('2013-9-30') group by username order by sum(jf) desc
以上查询出来的结果如下图：

如果只显示sum(jf)>10000的语句该怎么写？

Answer 1

select username,sum(jf) from a_log where addtime between date('2013-9-1') and date('2013-9-30') group by username having sum(jf)>10000
order by sum(jf) desc