select uid from T_TABLE Where num='3' and time between like

来源：学生作业帮编辑：作业帮分类：综合作业时间：2024/05/09 17:10:49

select uid from T_TABLE Where num='3' and time between like '200701%' and like '200702%'
我这条语句有错,请各位写出正确查询
本意是查uid,条件是 num=3 和时间time 在2007年1月到 2007年2月之间
between和like是不是不能一起用,怎么查好呢?
我的time字段是精确到秒的,所以要提出月份的
我的数据库不是SQL SERVER的
谢谢你的回答,期待更准确的答案

直接限定time在1月和2月不就可以了?
select uid from T_TABLE Where num='3' and time >= '20070101' and time

select uid from T_TABLE Where num='3' and time between like 这句话我还是看不懂,select count(1) from T_Late where T_Late.Uid = T_W SELECT * FROM T_DUTY WHERE dutyDate Between #2010-09-08# And 怎么把"select * from p_xiao where x_time between '{$dx}' and '{ SQL语句理解 select * from B where (select count(1) as num from A SELECT * FROM TABLENAME WHERE RQ BETWEEN '2007-7-4' AND '200 我用between and最后查出来了,Select * from [表名] where createtime betw SQL >select count(*) from Teacher where teacherCode=? and te SELECT name FROM [BookStore].[dbo].[user] WHERE userid=?AND select * from assets where assets.purchasedate between ${sta 英语翻译select top 4 * from shop_books where anclassid = (select select * from book where 1=1