wshanshi:个人使用记录… 一、 方法一 SELECT COALESCE ( sex, '总数' ), COUNT( id ) '人数' FROM test GROUP BY sex WITH ROLLUP; 二、方法二 SELECT count( 1 )总数, sum( CASE WHEN sex = 1 THEN 1 ELSE 0 END )男, sum( CASE WHEN sex = 0 THEN 1 ELSE 0 END ) 女 FROM test