【原】sql 查询结果合为一行
时间：2022-03-10 17:05
SELECT COUNT(*) AS AllCount,t.AssignedCount,(COUNT(*)-t.AssignedCount) AS
UnassignedCount
FROM 药品表
jOIN
(
SELECT COUNT(*) AS
AssignedCount
FROM 质量分析分配表
)as t on 1=1
group by
t.AssignedCount
【原】sql 查询结果合为一行,布布扣,bubuko.com
