有关select DBGrid的问题(1分)

M

mr.zy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-06

• #1

Table1
x1 x2
1.001 1.006
1.100 0.106
select x1 + x2 from table1
2.007
1.206
如果让它四舍五入留小数点后2位
变成:
2.01
1.21
.....................??????????

 

易

易名烦

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-06

• #2

select round(x1+x2,2) from table1

 

M

mr.zy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-06

• #3

谢谢,可惜我没多少分了!