50分求1句sql查询语句...在线等...解决问题马上给分！！！！

[Jorn]

问题是这样的:
我的表中有laidaotime,likaitime,totaltime,userid四个字段，我的sql语句要实现的功能是将userid相同的totaltime相加，而且我只需要laidaotime在firsttime和lasttime两个变量之间的数据！
我写的sql语句是：sql="select sum(totaltime) as ttime,userid,laidao from shijian where laidao between '"&firstdate&"' and '"&lastdate&"'" group by userid ，这个sql语句是错的！！！

[guo1wu3shi4]

select userid,sum(totaltime) from tablename where laidaotime >firsttime and laidaotime <lasttime group by userid

[Jorn]

guo1wu3shi4(guowushi），谢谢你帮助，但是还是错误，和我那句语句的错误一样

[ivy_ou]

select sum(totaltime) as ttime ,userid ,laidao from shijian where laidao between '"&firstdate&"' and '"&lastdate&"'" and userid in ( select userid from shijian group by userid)

[a_zhe_20]

sql="select sum(totaltime) as ttime,userid,laidaotime from shijian where laidaotime >#"&firstdate&"# and laidaotime<#"&lastdate&"# group by userid

你的表里没有laidao字段啊。

[ivy_ou]

楼主你想要什么数据呢?
sum(totaltime)和group by是聚合的,不能同时这样取userid,laidao 字断内容
是以什么排序呢?
是取每个人来到的最新来的时间,然后来到的总数?

[bullion]

SQL:

SELECT SUM(totaltime) as ttime,userid,laidao from shijian
where laidao between '"&firstdate&"' and '"&lastdate&"'"
GROUP BY userid,laido

[bullion]

GROUP BY 跟 SELECT SUM(totaltime) as ttime,userid,laidao 结合

如果SELECT里面带更多参数的话,GROUP BY 后要带更多的参数,如:

SELECT SUM(totaltime) as ttime,userid,laidao,aa,bb,cc
from shijian
where laidao between '"&firstdate&"' and '"&lastdate&"'"
GROUP BY userid,laido,aa,bb,cc