SELECT
ROUND( T1.co / T2.totalCo * 100, 2 )
FROM
( SELECT COUNT( * ) AS co FROM bi_workerman WHERE sex = 0 ) T1,
( SELECT COUNT( * ) AS totalCo FROM bi_workerman ) T2;
MYSQL 查询表 字段百分比
最新推荐文章于 2024-07-26 22:42:32 发布
SELECT
ROUND( T1.co / T2.totalCo * 100, 2 )
FROM
( SELECT COUNT( * ) AS co FROM bi_workerman WHERE sex = 0 ) T1,
( SELECT COUNT( * ) AS totalCo FROM bi_workerman ) T2;