征求SQL语句

Question

需要如下功能的SQL语句：
表A有三个字段aaa，bbb，ccc；三个字段的类型都是float,其中aaa和bbb有数据，ccc为空字段
现在要将每一条记录的bbb/aaa的值放入相应记录的ccc中，请教sql语句如何写？

Answer 1

update a
set ccc = bbb/aaa

Answer 2

update a
set ccc = bbb/aaa

Answer 3

update tb set ccc = bbb/aaa

Answer 4

--查询
select aaa , bbb , ccc = bbb/aaa from tb--更改
update tb set ccc = bbb/aaa

Answer 5

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

Answer 6

需要如下功能的SQL语句： 
表A有三个字段aaa，bbb，ccc；三个字段的类型都是float,其中aaa和bbb有数据，ccc为空字段 
现在要将每一条记录的bbb/aaa的值放入相应记录的ccc中，请教sql语句如何写？
--
update 表A set ccc=bbb/aaa

Answer 7

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 tbupdate tb set ccc = cast(bbb/aaa as decimal(10,2))select * from tbaaa 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呵呵 抢