为什么要写入一个表中呢?非得要用几个联合查询了。(select '' as fdesc,count(序号) as fcount from tablename where 日期 between '2001-1-1' and '2001-1-31') union (select 进出类型 as fdesc,count(序号) as fcount from tablename group by 进出类型) union (select 是否成功 as fdesc ,count(序号)as fcount from tablename group by 是否成功) union (select 进出类型+'-'+是否成功 as fdesc,count(序号) as fcount from tablename group by 进出类型,是否成功)
from tablename
where 日期 between '2001-1-1' and '2001-1-31')
union
(select 进出类型 as fdesc,count(序号) as fcount
from tablename
group by 进出类型)
union
(select 是否成功 as fdesc ,count(序号)as fcount
from tablename
group by 是否成功)
union
(select 进出类型+'-'+是否成功 as fdesc,count(序号) as fcount
from tablename
group by 进出类型,是否成功)