求一个简单相加查询

Question

select name,sum(count) from table group by name;

Answer 1

如果存在全角字符的话SQL> select * from tt;NAME       COUNT
---------- ----------
张         １．２３４
张         1.5已用时间:  00: 00: 00.20
SQL> select name,sum(translate(count,'０１２３４５６７８９．','0123456789.'))
  2  from tt group by name;NAME       SUM(TRANSLATE(COUNT,'０１２３４５６７８９．','0123456789.'))
---------- ------------------------------------------------------------
张                                                                2.734已用时间:  00: 00: 00.20
SQL>