Question

怎样把多个select count(*) 语句执行的结果合成一个sql语句啊？

比如：select count(*) from Flow_CreateProject_GX where companyid=95041
select count(*) from Flow_ProjectFinish where companyid=95041
select count(*) from Flow_SDSKJFZJH where companyid=95041
select count(*) from Flow_JNSKJFZJH where companyid=95041
把这四个查询结果合成一个sql语句，怎么做？？、急用

Answer 1

select count(a.*) as count1,count(b.*) as count2,count(c.*) as count3,count(d.*) as count4 from Flow_CreateProject_GX as a, Flow_CreateProject_GX as b,Flow_SDSKJFZJH as c,Flow_JNSKJFZJH as d where companyid=95041

Answer 2

select count(*) from Flow_CreateProject_GX where companyid=95041 union all
select count(*) from Flow_ProjectFinish where companyid=95041 union all
select count(*) from Flow_SDSKJFZJH where companyid=95041 union all
select count(*) from Flow_JNSKJFZJH where companyid=95041;

select sum(*) from (
select count(*) from Flow_CreateProject_GX where companyid=95041 union all
select count(*) from Flow_ProjectFinish where companyid=95041 union all
select count(*) from Flow_SDSKJFZJH where companyid=95041 union all
select count(*) from Flow_JNSKJFZJH where companyid=95041

)

Answer 3

union 后再来一个sum

追问

给我个例子吧！我不知道把sum写哪里啊？

Answer 4

箫剑无人:写的很简洁，顶你！