SELECT COUNT(1) FROM XT_YWGL_XMSBXX where xmid=1 and xxlb='主管部门指令文件' UNION SELECT COUNT(1) FROM XT_YWGL_XMSBXX where xmid=1 and xxlb='监理下发的停工令' UNION SELECT COUNT(1) FROM XT_YWGL_XMSBXX where xmid=1 and xxlb='即时报告' UNION SELECT COUNT(1) FROM XT_YWGL_XMSBXX where xmid=1 and xxlb='项目进度图片及说明' UNION SELECT COUNT(1) FROM XT_YWGL_XMSBXX where xmid=1 and xxlb='分部分项工程要点部位图片' UNION SELECT COUNT(1) FROM XT_YWGL_XMSBXX where xmid=1 and xxlb='其他'
你要是把各个结果用行的形式展现出来,按楼上几位的就可以了,如果想用列展现,则可以用下面的语句SELECT (SELECT COUNT(1) FROM XT_YWGL_XMSBXX where xmid=1 and xxlb='主管部门指令文件') AS count1, (SELECT COUNT(1) FROM XT_YWGL_XMSBXX where xmid=1 and xxlb='监理下发的停工令') AS count2, (SELECT COUNT(1) FROM XT_YWGL_XMSBXX where xmid=1 and xxlb='即时报告') AS count3, (SELECT COUNT(1) FROM XT_YWGL_XMSBXX where xmid=1 and xxlb='项目进度图片及说明') AS count4, (SELECT COUNT(1) FROM XT_YWGL_XMSBXX where xmid=1 and xxlb='分部分项工程要点部位图片') AS count5, (SELECT COUNT(1) FROM XT_YWGL_XMSBXX where xmid=1 and xxlb='其他') AS count6
SELECT COUNT(1) FROM XT_YWGL_XMSBXX where xmid=1 and xxlb='主管部门指令文件'
UNION
SELECT COUNT(1) FROM XT_YWGL_XMSBXX where xmid=1 and xxlb='监理下发的停工令'
UNION
SELECT COUNT(1) FROM XT_YWGL_XMSBXX where xmid=1 and xxlb='即时报告'
UNION
SELECT COUNT(1) FROM XT_YWGL_XMSBXX where xmid=1 and xxlb='项目进度图片及说明'
UNION
SELECT COUNT(1) FROM XT_YWGL_XMSBXX where xmid=1 and xxlb='分部分项工程要点部位图片'
UNION
SELECT COUNT(1) FROM XT_YWGL_XMSBXX where xmid=1 and xxlb='其他'
根据数据库不同,union可能需要改成union all,试验一下吧
select * from (这里是你那一堆sql)
W3C:SQL UNION 和 UNION ALL 操作符
(SELECT COUNT(1) FROM XT_YWGL_XMSBXX where xmid=1 and xxlb='主管部门指令文件') AS count1,
(SELECT COUNT(1) FROM XT_YWGL_XMSBXX where xmid=1 and xxlb='监理下发的停工令') AS count2,
(SELECT COUNT(1) FROM XT_YWGL_XMSBXX where xmid=1 and xxlb='即时报告') AS count3,
(SELECT COUNT(1) FROM XT_YWGL_XMSBXX where xmid=1 and xxlb='项目进度图片及说明') AS count4,
(SELECT COUNT(1) FROM XT_YWGL_XMSBXX where xmid=1 and xxlb='分部分项工程要点部位图片') AS count5,
(SELECT COUNT(1) FROM XT_YWGL_XMSBXX where xmid=1 and xxlb='其他') AS count6