SQL取小数2位 怎么才能让select 4/100 的结果是 0.04 保留2位小数,同时也要四舍五入.试过的回答 谢谢 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select cast(4*1./100 as dec(18,2)) select cast(4*1./100 as dec(18,2))++ cast(4*1.00/100 as dec(18,2)) select cast(4.0/100 as dec(18,2)) select cast(4.0/100 as dec(18,2)) 貌似select convert(dec(18,2),4.0/100 ) 也行 cast(4.0/100 as decimal(18,2))这也行呵呵 select cast(4.0/100 as decimal(14,2)) use tempdb;select cast(4 * 1.0/100 as decimal(18,2)); use tempdb;select cast(4 * 1.0/100 as decimal(18,2));select cast(4.5 * 1.0/100 as decimal(18,2));select cast(4.4 * 1.0/100 as decimal(18,2)); select cast(round(4.00/100,2) as decimal(18,2)) 四舍五入 最好加上 roundselect cast(round(1.0*4/100,2) as decimal(18,2)) select cast(4./100 as decimal(18,2)) mysql导入问题,探究 ACCESS里.替换指写表里指定列里指定的内容 sql,新手问题,谢谢 SQL2000的数据库如何导入到SQL2005Express中呢? 查询语句的效率讨论! 取前一个月分的数据怎么取 数据库取余 SQL与ACCESS间的转换问题(在线) 如何安装用Sql Server 作后台开发出来的系统? Help me!并发问题? 求一个查询语句 这样的要求能做到吗?控制字段对字段操作
select cast(4*1./100 as dec(18,2))
select cast(4*1./100 as dec(18,2))++
呵呵
select cast(4.0/100 as decimal(14,2))
use tempdb;select cast(4 * 1.0/100 as decimal(18,2));
use tempdb;select cast(4 * 1.0/100 as decimal(18,2));
select cast(4.5 * 1.0/100 as decimal(18,2));
select cast(4.4 * 1.0/100 as decimal(18,2));
select cast(round(4.00/100,2) as decimal(18,2))