select * from table where datetime='2002-06' or datetime='2002-05'
你需要的5月份的几个数据肯定是有条件的吧,在原条件后加一个or语句 select * from table where datetime='2002-06' or (datetime='2002-05' and ...) and后边再跟其他条件
select * from table where Year(DataTime)=2002 and Month(DateTime)=6 or DateTime='2002-05-XX'只要搞懂 Day,Month,Year ,DateAdd,DateDiff,DateName,DatePart,GetDate 这几个时间函数,任何时间问题都可轻松搞定!
同意楼上 select * from table where datetime='2002-06' or datetime='2002-05-31'
select * from table where datetime IN ('2002-06','2002-05')
select * from table where datetime='2002-06' or datetime in('2002-0501','2002-05-09')
select * from table where datetime='2002-06' or (datetime='2002-05' and ...)
and后边再跟其他条件
这几个时间函数,任何时间问题都可轻松搞定!
select * from table where datetime='2002-06' or datetime='2002-05-31'