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   1   else   0   end