select user_name from usre_info where user_id in('3','2','4,'3,'5','65') order by decode(user_id,'3',1,'2',2,'4',3......)
order by decode('3','1','2','2','4','3','3','4','5','5','65','6','7')
hehe: order by decode(user_id,'3','1','2','2','4','3','3','4','5','5','65','6','7')
既然用IN,又想得到排序,吃不下吧!select user_name from usre_info where user_id in('3','2','4,'3,'5','65') order by decode(user_id,'3',1,'2',2,'4',3,3,4,'5',5,'65',6,null) 以数字为星序,你试试看!! good luck
order by decode()是什么机制啊?
decode是译码机制,就是对于'3'->1,'2'->2,'4'->3.... 这样order by 就成了 order by 1,2,3...自然满足了, 巧妙啊!!!!!!!!!!!1
order by decode(user_id,'3','1','2','2','4','3','3','4','5','5','65','6','7')
good luck
这样order by 就成了 order by 1,2,3...自然满足了,
巧妙啊!!!!!!!!!!!1