SELECT count(*) AS 今日出货数量, SUM(CASE WHEN color_value = '蓝色' THEN 1 ELSE 0 END) AS 当日蓝色数量 FROM [test].[mo_data] WHERE Convert(varchar(10),[record_time],120) = Convert(varchar(10),getDate(),120)
优化这条语句分组查询 SELECT count(*) as 今日出货数量, (SELECT COUNT(*) FROM [test].[mo_data] WHERE color_value = '蓝色...
最新推荐文章于 2024-07-12 14:26:59 发布