--用这句SQL 语句,
Select Name,convert(char(10),Gz,4) as Gz from T_Gz
union all
Select '合计工资',convert(char(13),sum(Gz),4)
from T_Gz order by case when Name='合计工资' then 0 else 1 end
Select Name,convert(char(10),Gz,4) as Gz from T_Gz
union all
Select '合计工资',convert(char(13),sum(Gz),4)
from T_Gz order by case when Name='合计工资' then 0 else 1 end
Select Name,convert(char(10),Gz,4) as Gz from T_Gz
union all
Select '合计工资',convert(char(13),sum(Gz),4)
from T_Gz order by case when Name='合计工资' then 1 else 0 end
(
Select Name,convert(char(10),Gz,4) as Gz from T_Gz
union all
Select '合计工资',convert(char(13),sum(Gz),4))
from T_Gz) as a
order by case when Name='合计工资' then 1 else 0 end
Select Name,convert(char(10),Gz,4) as Gz from T_Gz order by Name
按 Name 排序
再加合计工资这一行或者"合计工资"这行不参加排序
from T_Gz
union all
Select '合计工资',convert(char(13),sum(Gz),4), 1 as fSort
from T_Gz
order by fSort, Name
order by Name
compute sum(Gz)
( Select 0 id,Name,convert(char(10),Gz,4) as Gz
from T_Gz
union all
Select 1 id,'合计工资',convert(char(13),sum(Gz),4)
from T_Gz ) as a
order by id,name
以上是WangZWang(阿来) 给的答案,