比如说一个表中有字段ID,ID为整型,按照5、7、3、9的次序排序
selete t.*,decode(t.id,5,1,7,2,3,3,9,4) as orderib from Table t where ID in (5,7,3,9) order by orderib
比如说一个表中有字段ID,ID为整型,按照5、7、3、9的次序排序
selete t.*,decode(t.id,5,1,7,2,3,3,9,4) as orderib from Table t where ID in (5,7,3,9) order by orderib