select * from 表
where
(datediff(day,时间字段,Getdate())=0
and fz=0 ) and
(
datediff(day,时间字段,dateadd(day,-1,Getdate()))=0
and fz!=0
)
where
(datediff(day,时间字段,Getdate())=0
and fz=0 ) and
(
datediff(day,时间字段,dateadd(day,-1,Getdate()))=0
and fz!=0
)
where fz = 0
and datediff(day,时间字段,getdate())=0
and exists(
select * from tb where fz<>0 and fid=a.fid and datediff(day,时间字段,getdate())=1)
另外请问exists的含义是什么,和oracle中哪个函数是一样的?