SQL SERVER AND和OR的使用 

 SELECT * FROM t_overtime WHERE apptype=0 AND (audit=1 or audit=2) AND 
 addtime BETWEEN '2011-10-01' AND '2011-10-20 23:59:59' order by addtime desc

　　

posted @ 2011-10-20 11:45  becket  阅读(92)  评论(0)  编辑  收藏  举报