请高手帮忙

[cdsgajxlp]

请高手告诉我如何设置？
select count(*)/6.0 from zz,显示的是0.166666（zz中只有一条数据），我想显示的结果生成的小数位数根据我除的数的小数位数来确定
如：select count(*)/6.0 from zz 结果中有一位小数
select count(*)/6.00 from zz 结果中有二位小数

[ppp005]

str

[sdhdy]

select cast(count(*)/6.0 as decimal(13,2)) from zz

用cast 或convert函数，用法参见连机帮助

[gmlxf]

SELECT CAST((count(*)/6.0) AS NUMERIC(38,1)) FROM zz
SELECT CAST((count(*)/6.00) AS NUMERIC(38,2)) FROM zz

[gmlxf]

SELECT
比值 =
(SELECT COUNT(*) FROM T WHERE <被借过条件>) * 1.0
/
(SELECT COUNT(*) FROM T)

[gmlxf]

发错地方了，抱歉。