求一SQL语句!!!!谢谢!!!!!!~~~~~~~ ( 积分: 50 )

Z

zuping

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-18

• #1

mwork表：会员下载软件的记录
id counter primary key, userip char(30), userid Integer,softid Integer,soft char(10),workDate DateTime

softid=下载软件的ID
每下载1次，就增加1条记录，想统计各个软件的下载次数

怎么写SQL？

 

X

xxj0828

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-18

• #2

select count(softid) as downcount
from mwork
group by softid

 

C

cyndi_blue

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-18

• #3

嗯，楼上的没错。。

 

Z

zuping

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-18

• #4

补充:

我用的是ASP，怎么取 结果啊，希望讲清楚点

sql="select count(softid) as downcount from mwork group by softid"
set rs=conn.Execute(sql)
Response.write("<tr><td>"&rs(0)&"</td></tr>&quot

最后这个就出错了，不懂怎么取各个软件的下载次数，ASP俺也菜，帮帮助下，感谢！

 

G

guanrui

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-18

• #5

select count(id) as downcount
from mwork
group by softid
这样也行 呵呵~ 就是个统计 用下COUNT函数就OK