SQL server where if or 条件判断
select fno,fname,remark1from t_base where fparentid='159' or fparentid='169'order by cast(remark1 as int)asc得到的结果为两组数据同时显示,想要达到某种条件下显示其中一个网上较好方法为WHERE IF( `parentID` =1, `plan_id` <10, `plan_id...
原创
2018-05-26 13:15:09 ·
26485 阅读 ·
2 评论