Question

sql server 查询两列对应比值

比如有下表 id是流水不管，，如何得出 A列比上B列的对应的值
id A B 得出这个表 id A B c
45 100 45 100 0.45
67 120 67 120 0.56
34 87 34 87 0.39

Answer 1

select a,b , round(a/b,2) as c from table

Answer 2

select a,b,(a/b) as 对应值 from 表名

Answer 3

select a,b,(a/b) as c from xxxx

Answer 4

select *,convert(decimal(10,2),(a/convert(float,b))) as c from table