select DECODE(C.ID,‘3926dc5252c74252aa52535508bec475’,1 ,‘4f250de78d4c4655a4a704a3b9fc48ab’,2,‘59816b9cc23644639e94edc941564ebc’,3) AS SX ,
C.* FROM 表名 C WHERE ID IN(‘59816b9cc23644639e94edc941564ebc’,‘4f250de78d4c4655a4a704a3b9fc48ab’,‘3926dc5252c74252aa52535508bec475’) ORDER BY SX DESC;
Oracle的DECODE的使用,按照指定排序
最新推荐文章于 2024-05-17 14:36:35 发布