求一条Sql语句

[fangq]

表如下:
USer Count
-------------
A 1
B 2
C 1
A 3
B 1
C 5
B 5
.....
如何求出Count中累加和大于5的User
应该有B,C

[笨笨兔兔兔兔兔]

select [user] from tryfangq group by [user] having sum([count])>5

[笨笨兔兔兔兔兔]

A 1
A 2
B 1
B 1
B 5
C 5
C 1

tryfangq 表里的值

[unixpeter]

dim i,j
i=0
do while not rs.eof and i<rs.recordcount
i=i+1
j=rs("number")
if j(i)+((j)(i)+1)>5 then
response.write(id)
end if
rs.movenext
loop

[pcaixh]

select [User]
from Test
group by [User]
having sum([count]) > 5

[iyaya]

SELECT SUM(Count)
FROM table_name
GROUP BY USer
HAVING SUM(Count) > 5

[zheng_hz]

CREATE TABLE #TABLE1 (
[USER] VARCHAR(1),[COUNT] INT
)

INSERT INTO #TABLE1 VALUES ('A',1)
INSERT INTO #TABLE1 VALUES ('B',2)
INSERT INTO #TABLE1 VALUES ('C',1)
INSERT INTO #TABLE1 VALUES ('A',3)
INSERT INTO #TABLE1 VALUES ('B',1)
INSERT INTO #TABLE1 VALUES ('C',5)
INSERT INTO #TABLE1 VALUES ('B',5)


SELECT [USER],SUM([COUNT]) AS [COUNT] FROM #TABLE1
GROUP BY [USER]
HAVING SUM([COUNT])>5
DROP TABLE #TABLE1