select * FROM TABLENAME WHERE (SEX='男' and datediff(Month,birthday,getdate())=723 ) or (SEX='女' and datediff(Month,birthday,getdate())=663)
try select * from @t where dateadd(year,60,date) between dateadd(month,-3,getdate()) and getdate() and SEX='男' or (dateadd(year,55,date) between dateadd(month,-3,getdate()) and getdate() and SEX='女')
try select * from 表 where dateadd(year,60,出生日期) between dateadd(month,-3,getdate()) and getdate() and 性别='男' or (dateadd(year,55,出生日期) between dateadd(month,-3,getdate()) and getdate() and 性别='女')
select * FROM TABLENAME WHERE
(SEX='男' and datediff(Month,birthday,getdate())=723 )
or
(SEX='女' and datediff(Month,birthday,getdate())=663)
select * from @t
where dateadd(year,60,date) between dateadd(month,-3,getdate()) and getdate()
and SEX='男' or
(dateadd(year,55,date) between dateadd(month,-3,getdate()) and getdate()
and SEX='女')
try
select * from 表
where dateadd(year,60,出生日期) between dateadd(month,-3,getdate()) and getdate()
and 性别='男' or
(dateadd(year,55,出生日期) between dateadd(month,-3,getdate()) and getdate()
and 性别='女')