SQL²éѯÓï¾ä

select sum(column1) as column1,sum(column2) as column2 ..... from tb

ÎÒÕâÀïSUM³öÀ´½á¹û¿ÉÄÜÈçÏÂ
  column1    columns2 ......
  12.010      22.4300
  42.510      43.5500

ÓÐûÓа취1¾äSQLÈÃËû¶¼ÊDZ£Áô2λСÊý


½á¹ûÈçÏÂ
  column1    columns2  ......
  12.01      22.43
  42.51      43.55

---

²»ÄÜÐ޸ıí½á¹¹

---

convert(numeric(18,2),欄λ)

---

select convert(numeric(18,2),sum(column1)) as column1,

convert(numeric(18,2),sum(column2)) as column2 .....

from tb

---

numeric(18,2)

---

SQL code:
CONVERT(DEC(18,2),..)

---

select cast(sum(column1) as numeric(18,2)) as column1
...

---

cast (sum(xx) as decimal(10,2)

---

SQL code:
cast(col as dec(18,2))