百分率:
select test = convert(char(4),round(convert(float,n1)/n2,3)*100)+ '% '
判断除数不为0:
select test=
case " (n2)
when '0' then '0%'
ELSE
convert(char(5),round(convert(float,(n1 ))/(n2),4)*100)+ '% ' END
n1 被除数,n2 除数。
当除数为0 的时候结果就显示成0%
横向列表:
select
(SQL1) as 别名1
(SQL2) as 别名2
(SQL3 ) as别名3
(SQL4) as 别名4
(SQL5) as 别名5
(SQL6) as 别名6