一个mysql的问题,求助。。。

一个mysql的问题,求助。。。

select a.mp,a.title,a.addtime,b.id2,b.point_spare,b.point_deduct from mp_mpactivity AS a left join sec_secretary AS b on a.mp=b.id2 where b.point_spare>='9' AND b.point_spare>=b.point_deduct order by a.addtime desc limit 0,6

上面的语句结果是得到符合条件的数据的前6条,我现在要得到符合数据的总个数,该怎么改?大家帮帮忙,谢谢了!

不要后面的limit
select a.mp,a.title,a.addtime,b.id2,b.point_spare,b.point_deduct from mp_mpactivity AS a left join sec_secretary AS b on a.mp=b.id2 where b.point_spare>='9' AND b.point_spare>=b.point_deduct order by a.addtime desc
毕业了。。。