sql server 查询两列对应比值

2025-03-06 18:33:30
推荐回答(4个)
回答1:

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

回答2:

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

回答3:

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

回答4:

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