求助 SQL的计算问题

[twoXtree]

有个表结构是 id_no,money1,num1
现在要计算id_no相同的money1的和、num1的和
请问这个语句怎么写呢，初学这个不大了解、、、

[百年树人]

select id_no,sum(money1) as smoney,sum(num1) as ssum
from tb
group by id_no

[Felixzhaowenzhong]

[Quote=引用 1 楼 的回复:]
SQL code

select id_no,sum(money1) as smoney,sum(num1) as ssum
from tb
group by id_no
[/Quote]

++

[孤独加百列]

[Quote=引用 1 楼 的回复:]

SQL code
select id_no,sum(money1) as smoney,sum(num1) as ssum
from tb
group by id_no
[/Quote]
顶一个

[twoXtree]

晕死，不好意思一楼大大，结分给错了。。。。。