请教一个SQL的除法过程----在线等

[jia19861029]

数据库为：sql server2000
SQL语句为：
select distinct pname,
(select count(*) from baseinfo as a where (jjgz='1' or jjgz='2') and a.pname=b.pname ) as count1,
(select count(*) from baseinfo as a where a.pname=b.pname ) as count2 ,

(select count(*) from baseinfo as a where (jjgz='1' or jjgz='2') and a.pname=b.pname )/
(select count(*) from baseinfo as a where a.pname=b.pname ) as count3
from baseinfo as b order by count1 desc

得到的结果为：
pname count1 count2 count3
张三 1101 1104 0



如何让count3有小数点后四位或者更多呢？如何给count3加上“%”号呢？

[不姓贾_请叫我甄先生]

应该有专门的操作函数吧？sql server的不是很清楚

[justwalking]

放到sql版里去问问

[BearKin]

http://topic.csdn.net/u/20090602/16/665f8edb-9956-498c-8688-c1ae3a82b4f9.html
去香港GOOGLE搜索的 看看吧..

[pjw100]

1.定义变量
2.count1,count2都转成decimal类型后相除
3.略

[Callsin]

给你一个思路，你先试试~~

select Convert(varchar,convert(decimal(15,5),(convert(float,count1 )/count2  *100)) )+'%'

[jia19861029]

回5楼:
当遇到除零呢?

[jia19861029]

恩好了,

[jia19861029]

问题解决了.除错了,谢谢楼上各位,谢谢谢谢.