sql简单问题select5/10asaafromtb不知什么原因查询出来的结果是0请问大家应该怎么操作显示为0.5呢?[解决办
sql简单问题
select 5/10 as aa from tb
不知什么原因查询出来的结果是 0
请问大家应该怎么操作显示为0.5呢?
[解决办法]
select (5.0/10.0) as aa from tb
[解决办法]
create table test
(
a int,
b int
)
INSERT INTO TEST (A,B) VALUES (1,2)
INSERT INTO TEST (A,B) VALUES (3,4)
INSERT INTO TEST (A,B) VALUES (3,5)
INSERT INTO TEST (A,B) VALUES (7,10)
select cast(a as decimal)/cast(b as decimal) from test
0.50000000000000000000000000
0.75000000000000000000000000
0.60000000000000000000000000
0.70000000000000000000000000