SQL问题 高手进!]

[treasonboy]

有个表格式:
时间 名称 数量
------------------

我想查询名称为 "ABS" 时间在2006-11-1到2006-12-1之间的

对了的话追加分数 谢谢!!

[caixia615]

select * from tablename where 名称='ABS' and 时间 between '2006-11-1' and '2006-12-1'

[子陌红尘]

select * from tablename where 名称='ABS' and 时间>='2006-11-1' and 时间<'2006-12-2'

[leo_lesley]

select * from table_name where 名称='ABC' and 时间 between '2006-11-1' and '2006-12-1'

[marco08]

select * from tablename where 名称='ABS' and 时间 between '2006-11-1' and '2006-12-1'

[kourr2004]

select * from table_name where 名称＝'ABC'
and datediff(day,时间,'2006-11-01') <= 0
and datediff(day,时间,'2006-12-01') >= 0
楼主给分：）

[slimfeng]

select * from tablename where 名称='ABS' and 时间 between '2006-11-1' and '2006-12-1'
今天就由于'2006-11-1' 等时间没有加单引号，调试程序浪费了一个小时，郁闷

[treasonboy]

我要的是数量总和

[sujinlin]

select sum(数量) from tablename where 名称='ABS' and 时间 between '2006-11-1' and '2006-12-1'

[lengyu0908]

select * from tablename where 名称='ABS' and 时间<='2006-12-2' and 时间<'2006-11-1'