按照自定义的顺序排序:select * from table_name order by decode(col_name,'value1',1,'value2',2,'value3',3,'value4',4,...valueN',N);```![在这里插入图片描述](https://img-blog.csdnimg.cn/5f2b68f2566544ad99bcd38d3e8ecf90.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shad