如何在数据库中查询 一个时间段里面的数据。2次筛选

[hui131486]

select * from sd where dengjiren='伟哥' and exists (select * from sd where shijian between '2015-12-00' and '2015-12-09');

[Ginnnnnnnn]

写在一齐不行吗？ select * from sd where dengjiren='伟哥' and shijian between '2015-12-00' and '2015-12-09'

[benluobo]

select * from sd where dengjiren='伟哥' and shijian between '2015-12-00' and '2015-12-09'

[文修]

楼主你好 如果你的表时间字段是Datetime型 以" YYYY-MM-DD 00:00:00" 存放，那么代码为

select * from sd where dengjiren='伟哥' and  shijian between '2015-12-00 xx:xx:xx' and '2015-12-09 xx:xx:xx'

如果表的时间字段是Datetime型以" YYYY-MM-DD"存放，那么代码为：

select * from sd where dengjiren='伟哥' and  shijian between '2015-12-00' and '2015-12-09'

[LongRui888]

select * from sd where dengjiren='伟哥' and exists (select * from sd where shijian between '2015-12-00' and '2015-12-09'); 直接把exists去掉，不用写这么复杂，你是一个表，不是两个表