declare @tb table(A datetime)
insert @tb
select '2010/8/9' union all
select '2010/9/9' union all
select '2010/10/1' union all
select '2010/10/2' union all
select '2010/10/3' select A from @tb where dateadd(dd,-3,A) < '2010/9/30'/*
A
------------------------------------------------------
2010-08-09 00:00:00.000
2010-09-09 00:00:00.000
2010-10-01 00:00:00.000
2010-10-02 00:00:00.000
*/
有出来啊
FROM Dm_WbAordera
WHERE Out_CDate<'2010/10/3'不太明白你的意思~
但是如果Out_CDate是'2010/10/1'并沒有出現。
請問要如何寫,查詢出的數據才有包括Out_CDate是'2010/10/1'、'2010/10/2'、'2010/10/3'。这两个要求不是矛盾了吗?囧~~~
FROM Dm_WbAordera
WHERE Out_CDate>='2010/10/1'
FROM Dm_WbAordera
WHERE Out_CDate>='2010/10/1'
order by Out_CDate