关于SQL语句,该怎么解决

关于SQL语句
将数据库表“A” 里面的列 “A1”里面所有的数值全部除以2，这个语句怎么写，谢谢大家帮下忙啊，

[解决办法]

SQL code

update A set A1=A1/2
[解决办法]
SQL code
select A1*2 from A ;
[解决办法]
SQL code
select A1/2 from A ;
[解决办法]
SQL code
update A set A1=A1/2.00
[解决办法]
SQL code
select A1/2 as A1 FROM A
[解决办法]
SQL code
select A1/2.0 as A1 FROM A