<script type=text/javascript>
</script><script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type=text/javascript> </script>
<script type=text/javascript>
</script><script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type=text/javascript> </script>
表字段 id username point
1 a 1
2 b 5
3 c 8
4 a 10
5 b 5
6 a -1
7 b 20
要显示结果
b 30
c 8
去掉有负数的用户a
我用户的错误语句是
rs0.open "select username, sum(point)as point from tab where username not in(select point<0 group by username) and point>0 group by username",conn,1,1
==========================================================
select username, sum(point) as point
from tab
where username not in (select username from tab where point<0 )
and point > 0
group by username