sql语句中and和between and能在一块用吗

[不好说]

比如说我要查询今天（时间条件）所有qid等于1的记录

[不好说]

先在这里谢谢各位！

[不好说]

select count(*) from yuyue where (yysj between '"&ndate&" 00:00:00' and '"&ndate&" 23:59:59') and (qid='1')我这样写还不行啊

[dawugui]

select * from tb where qid = 1 and datediff(dd,getdate(),时间字段) = 0

[ILOVE_ASPNET]

SELECT * FROM Orders WHERE CreatedOn BETWEEN '2012-2-2' AND '2012-2-15' AND OrderID='FPTEE93852K3'

[ILOVE_ASPNET]

SORRY 看错了，要查询当天的是吧

SELECT * FROM Orders WHERE OrderID='FPTEH97817X1' AND CreatedOn BETWEEN DATEADD (DAY,-1,GETDATE()) AND GETDATE()

[babydog01]

[Quote=引用 2 楼 ilove_aspnet 的回复:]
SELECT * FROM Orders WHERE CreatedOn BETWEEN '2012-2-2' AND '2012-2-15' AND OrderID='FPTEE93852K3'
[/Quote]
怕自己看不明白， 加上括号就可以了。
SELECT * FROM Orders WHERE (CreatedOn BETWEEN '2012-2-2' AND '2012-2-15') AND (OrderID='FPTEE93852K3')

[ILOVE_ASPNET]

[Quote=引用 4 楼 babydog01 的回复:]

引用 2 楼 ilove_aspnet 的回复:
SELECT * FROM Orders WHERE CreatedOn BETWEEN '2012-2-2' AND '2012-2-15' AND OrderID='FPTEE93852K3'

怕自己看不明白， 加上括号就可以了。
SELECT * FROM Orders WHERE (CreatedOn BETWEEN '2012……
[/Quote]

呵呵楼上很细心，我没看清楚他要查询当天的，我以为是问between 和 and 是否能同时用这个问题，没仔细看。

[AcHerat]

select * from tbname
where col1 between ... and ...
and ...
and ...

可以直接连用。

[大力水手]

--借用小三代码
select * from tbname 
where col1 between ... and ...
  and ...
  and ...

可以直接连用。

[叶子]

可以放到一块使用！