Sql server语法如下：

select * from 表名
where 列名 in ('条件1','条件2','条件3','条件4')
order by charindex(列名, '条件1,条件2,条件3')

DM改写如下：

select * from 表名
where 列名 in ('条件1','条件2','条件3','条件4')
order by decode(列名, '条件1',1,'条件2',2,'条件3',3)