复选框 多条件查询、年龄
select * from rck where glyStatus in (1,2,3) and bfStatus=0 and delStatus=0 and status in (2,3)select count(*) from rck where glyStatus in (1,2,3) and bfStatus=0 and delStatus=0 and status in (2,3) and rck_rcfl like '%市优秀拔尖人才%' --18select count(*) from rck where glyStatus in (1,2,3) and bfStatus=0 and delStatus=0 and status in (2,3) and rck_rcfl like '%企业经营管理人才%' --8--查询人才分类select * from rck where glyStatus in (1,2,3) and bfStatus=0 and delStatus=0 and status in (2,3) and (rck_rcfl like '%市优秀拔尖人才%' or rck_rcfl like '%企业经营管理人才%' )select * from rck where glyStatus in (1,2,3) and bfStatus=0 and delStatus=0 and status in (2,3) and (rck_rcfl like '%市优秀拔尖人才%' and rck_rcfl like '%企业经营管理人才%' )--查询学位select * from rck where glyStatus in (1,2,3) and bfStatus=0 and delStatus=0 and status in (2,3) and rck_qrzxl in('博士研究生','硕士研究生','中专','大学专科')--人才分类和学历综合查询select * from rck where glyStatus in (1,2,3) and bfStatus=0 and delStatus=0 and status in (2,3) and (rck_rcfl like '%晋中籍在外工作的高层次人才%' or rck_rcfl like '%企业经营管理人才%' ) and rck_qrzxl in('博士研究生','硕士研究生','中专','大学专科') --按照年龄查询select * from rck where glyStatus in (1,2,3) and bfStatus=0 and delStatus=0 and status in (2,3) and ((datediff(year,rcl_csrq2,getdate())-case when datediff(day,dateadd(year,datediff(year,rcl_csrq2,getdate()),rcl_csrq2),getdate()) >=0 then 0 else 1 end) <=20 or(datediff(year,rcl_csrq2,getdate())-case when datediff(day,dateadd(year,datediff(year,rcl_csrq2,getdate()),rcl_csrq2),getdate()) >=0 then 0 else 1 end) between 36 and 40 or(datediff(year,rcl_csrq2,getdate())-case when datediff(day,dateadd(year,datediff(year,rcl_csrq2,getdate()),rcl_csrq2),getdate()) >=0 then 0 else 1 end) between 55 and 60 or(datediff(year,rcl_csrq2,getdate())-case when datediff(day,dateadd(year,datediff(year,rcl_csrq2,getdate()),rcl_csrq2),getdate()) >=0 then 0 else 1 end) >=61 )?