sql分组求和

[风中云]

如题：
表结构：[entid] varchar，[smstotal] int，[smscharge] int，[smsentertime] datetime
要根据entid分组求smstotal，smscharge这两列的和，sql语句是这样的：
select entid,sum(smstotal),sum(smscharge) from qmsg_addsmsmmslog group by entid
但是我要限定时间（smsentertime）要怎么写啊？

[开着拖拉机泡妞]

select entid,sum(smstotal),sum(smscharge) from qmsg_addsmsmmslog where (时间的条件) group by entid

[dawugui]

select entid,sum(smstotal),sum(smscharge) from qmsg_addsmsmmslog where smsentertime = ... group by entid

select entid,sum(smstotal),sum(smscharge) from qmsg_addsmsmmslog where smsentertime between ... and ... group by entid

[kingtiy]

select entid,sum(smstotal),sum(smscharge) from qmsg_addsmsmmslog 
where smsentertime >=? --加个where
group by entid

[jp78070531]

加个时间字段的条件

[开着拖拉机泡妞]

--指定某一个时间
select entid,sum(smstotal),sum(smscharge) from qmsg_addsmsmmslog where date=xxx group by entid
指定在某个范围内
select entid,sum(smstotal),sum(smscharge) from qmsg_addsmsmmslog where datebetween xxx and xxx group by entid
--指定不在某个范围内
select entid,sum(smstotal),sum(smscharge) from qmsg_addsmsmmslog where date not between xxx and xx group by entid

--指定为多个特定时间
select entid,sum(smstotal),sum(smscharge) from qmsg_addsmsmmslog where date in (子查询返回多个特定时间) group by entid

[风中云]

我在数据库中执行这个sql时，结果是正确的，但是我在myeclipse中调试时怎么entid总是8呢，并且sum(smscharge)和sum(smstotal)的值相同，这个是怎么回事啊