条件语句里
取时间在两个时间段里的记录
2010-10-01 大于datefrom小于 2010-10-10
和
2010-12-01 大于datefrom小于 2010-12-10
取时间在两个时间段里的记录
2010-10-01 大于datefrom小于 2010-10-10
和
2010-12-01 大于datefrom小于 2010-12-10
解决方案 »
- 刚注册的,各位多帮忙。有问题,问题是删除索引的问题
- 关于sql server中varbinary(max)类型的问题
- 新建注册时候出现 sql server 不存在或访问被拒绝
- SQL 2005 CTP 版的数据库无法挂到正式版了?有什么办法吗?急啊!!
- 查询数据!!!!!!!!!!!!!!
- 我的一张SQL 数据表有25G,普通的SQL 语句根本查不动,请教一下,有什么高效率的方法吗?
- Sql 2000 在win2003 上安装出现的问题!
- 救命,MSSQLSERVER2005如何恢复上一步操做
- 连接远程数据服务器错误:我是ISDN 拨号上网~~~
- sql 2005中表不能操作
- 询问并发问题
- 关于存储过程的Return返回值
where (datefrom < '2010-10-10' and datefrom > '2010-10-01')
or
(datefrom < '2010-12-10' and datefrom > '2010-12-01')
or
(datefrom < '2010-12-10' and datefrom > '2010-12-01')同意,然后稍微注意一下 如果 datefrom 为 字符类型而不是 日期类型的话 要 cast 转换一下类型
or
datefrom between '2010-12-01' and '2010-12-10'不过这样感觉效率有点低,呵呵。
where datefrom between '2010-10-01' and '2010-10-10'
or
datefrom between '2010-12-01' and '2010-12-10'
--方法二 ,用or效率不会太高
where dateform >'2010-10-01' and datefrom <'2010-10-10'
or
dateform>'2010-12-01' and datefrom<'2010-12-10'
where (datefrom between '2010-10-01' and '2010-10-10')
or
(datefrom between '2010-12-01' and '2010-12-10')
--方法二 ,用or效率不会太高
where (dateform >'2010-10-01' and datefrom <'2010-10-10')
or
(dateform>'2010-12-01' and datefrom<'2010-12-10')
or
(datefrom < '2010-12-10' and datefrom > '2010-12-01')
or
(datefrom < '2010-12-10' and datefrom > '2010-12-01')
or
(datefrom < '2010-12-10' and datefrom > '2010-12-01')
where (datefrom between '2010-10-01' and '2010-10-10')
or
(datefrom < '2010-12-01' and '2010-12-10')
select * from tablename where (datefrom between '2010-10-10' and '2010-10-01')
or
(datefrom < '2010-12-01' and '2010-12-10')
<条件>
or
union all
select * from tablename where (datefrom < '2010-12-10' and datefrom > '2010-12-01')
效率高点
union all
select * from tablename where (datefrom < '2010-12-10' and datefrom > '2010-12-01')
用这个,绝对没错的。速度快高效率