34,590
社区成员
发帖
与我相关
我的任务
分享
nsert into tb values(5.7 , 2.2 , null)
insert into tb values(2.2 , 3.3 , null)
insert into tb values(3.34 , 4.6 , null)
insert into tb values(4.2 , 3.4 , null)
insert into tb values(5.6 , 2.3 , null)
select aaa , bbb , ccc = cast(bbb/aaa as decimal(10,2)) from tb
update tb set ccc = cast(bbb/aaa as decimal(10,2))
select * from tb
aaa bbb ccc
5.7 2.2 0.39
2.2 3.3 1.5
3.34 4.6 1.38
4.2 3.4 0.81
5.6 2.3 0.41
create table tb(aaa float , bbb float , ccc float)
insert into tb values(1.0 , 2.0 , null)
insert into tb values(2.0 , 3.0 , null)
insert into tb values(3.0 , 4.0 , null)
insert into tb values(4.0 , 5.0 , null)
insert into tb values(5.0 , 6.0 , null)
go
--查询
select aaa , bbb , ccc = bbb/aaa from tb
/*
aaa bbb ccc
----------------------------------------------------- ----------------------------------------------------- -----------------------------------------------------
1.0 2.0 2.0
2.0 3.0 1.5
3.0 4.0 1.3333333333333333
4.0 5.0 1.25
5.0 6.0 1.2
(所影响的行数为 5 行)
*/
--更改
update tb set ccc = bbb/aaa
select * from tb
/*
aaa bbb ccc
----------------------------------------------------- ----------------------------------------------------- -----------------------------------------------------
1.0 2.0 2.0
2.0 3.0 1.5
3.0 4.0 1.3333333333333333
4.0 5.0 1.25
5.0 6.0 1.2
(所影响的行数为 5 行)
*/
drop table tb
--查询
select aaa , bbb , ccc = bbb/aaa from tb
--更改
update tb set ccc = bbb/aaa
update a
set ccc = bbb/aaa
update a
set ccc = bbb/aaa