求一簡單SQL語句，解決即給100分，在線等……

[TaoHuang]

我是用SQL7.0的， 如果Table1中有一個日期字段FieldDate1，現我想取出Table1中所有從FieldDate1日期到現在GetDate()大於或等於3天的記錄（FieldDate1－GetDate()＞＝3），但是FieldDate1到GetDate()這3日中如果有星期天，則不能在3天內，即從FieldDate1到GetDate()不包含星期天，且大於或等於3天的記錄。要求用SQL語句實現，解決即給100分，先答先得，在線等……

[pnnm]

up

[txlicenhe]

Select * from Table1
where datediff(day,FieldDate1,getdate())>3
or (datediff(day,FieldDate1,getdate())=3 and datepart(weekday,FieldDate1)<datepart(weekday,getdate()) )

[wzh1215]

select * from table where datediff(DY,getdate(),fieldDate1)>=3 and datepart(DW,FieldDate1])=1

[wzh1215]

select * from table1 where datediff(DY,getdate(),fieldDate1)>=3 and datepart(DW,FieldDate1])=1

[wzh1215]

select * from table1 where datediff(DY,fieldDate1,getdate())>=3 and datepart(DW,FieldDate1])<>1

[pengdali]

select * from table1 where datediff(day,fieldate1,getdate())>=case when datepart(weekday,getdate())<4 then 4 else 3 end

[pengdali]

如果上面不是：

select * from table1 where datediff(day,getdate(),fieldate1)>=case when datepart(weekday,getdate())<4 then 4 else 3 end

[pengdali]

如果是要找小于于系统时间3天以上的:

select * from table1 where datediff(day,fieldate1,getdate())>=case when datepart(weekday,getdate())<4 then 4 else 3 end


如果是要找大于于系统时间3天以上的：

select * from table1 where datediff(day,getdate(),fieldate1)>=case when datepart(weekday,fieldate1)<4 then 4 else 3 end

[zjcxc]

select * from table1
where FieldDate1-GetDate()>=3 and datepart(weekday,FieldDate1)<>1

[pengdali]

如果是要找大于于系统时间3天以上的 或用：

select * from table1 where datediff(day,getdate(),fieldate1)>=case when datepart(weekday,getdate())>5 or datepart(weekday,getdate())=1 then 4 else 3 end

[xjwxiong]

馬可 和大力的 都對
該問題其實關鍵是在等於3天並且不包含星期天的資料

處理好了這個
應該就OK

[qwer1234333]

Select * from Table1
where datediff(day,FieldDate1,getdate())>=3
and datepart(weekday,FieldDate1)<datepart(weekday,getdate()) )

[TaoHuang]

過段時間較忙，所以遲遲未能結貼。謝謝大家。