这个是流传在我们公司内部BBS上的图片。

记录一下group by的用法，省得每次都要google

SELECT count( DISTINCT f_id ) AS num
FROM t_check_quan_0806
WHERE f_checked_time >= '2008-06-01 00:00:00'
AND f_checked_time <= '2008-06-31 00:00:00'
AND f_manager_name = 'wangyf'
AND (
f_status = '3'
OR f_status = '4'
)
GROUP BY f_status
LIMIT 0 , 30 

SELECT msg_type, count(account) as num FROM $msg_exp_tbl group by msg_type