sql插入语句满足条件下插入如何做

1、不知道你说的是哪种情况，我理解的有2种，1是对插入源进行过滤，2是对插入的某些值作判断，是某个特定值时转换成另一个值。

3、Select id,name,status，remark From (Select 1 as id,'稆糨孝汶;张三' as name,'在职' as status,'没有备注' as remark Union Select 2,'李四','离职','') as s Where id>2 And id<5--条件

5、Select 1 as id,'张三' as name,'在职' as status,'没有备注' as remark Union Select 2,'李四','离职',') as s。