34,590
社区成员
发帖
与我相关
我的任务
分享
select * from tb
where datediff(day,brithday,getdate())/365>=( case when sex='男' then 60 when sex='女' and station='领导' then 55 when sex='女' and station='工人' then 50 end)
select * from tb
where sex='男' and Brithday<= dateadd(year,-60,dateadd(month,-3,getdate()))
or sex='女' and 岗位='领导' and Brithday<= dateadd(year,-55,dateadd(month,-3,getdate
()))
or sex='女' and 岗位='工人' and Brithday<= dateadd(year,-50,dateadd(month,-3,getdate
()))
select * from tb
where sex='男' and Brithday<= dateadd(year,-60,dateadd(month,-3,getdate()))
or sex='女' and 岗位='领导 and Brithday<= dateadd(year,-55,dateadd(month,-3,getdate
()))
or sex='女' and 岗位='工人' and Brithday<= dateadd(year,-50,dateadd(month,-3,getdate
()))
select * from employee where abs(datediff(M,dateadd(y,birthday, case when sex='男' then 60
when 性别='女' and Station='领导' then 55 else 50 end),getdate()))<=3