SELECT SUM
( CASE WHEN area_name IS NULL THEN 0 ELSE 1 END ) AS '有值',
COUNT ( id ) AS "总数"
FROM
beike_property
sqlserver实现分类汇总
最新推荐文章于 2024-07-31 13:38:36 发布
SELECT SUM
( CASE WHEN area_name IS NULL THEN 0 ELSE 1 END ) AS '有值',
COUNT ( id ) AS "总数"
FROM
beike_property