想去改变这个排序,谁有办法,大家一起学习学习。
先创建表,如下:
CREATE TABLE old_temp_order (userid VARCHAR2(20) PRIMARY KEY,username VARCHAR2(20));
INSERT INTO OLD_TEMP_ORDER (USERID, USERNAME) VALUES ('10120110514051', '第一'); INSERT INTO OLD_TEMP_ORDER (USERID, USERNAME) VALUES ('10120110514052', '第二'); INSERT INTO OLD_TEMP_ORDER (USERID, USERNAME) VALUES ('10120110514053', '第三');
10120110514053 第三10120110514052 第二10120110514051 第一
SELECT USERID, USERNAME FROM OLD_TEMP_ORDER WHERE USERID = '10120110514053' UNION ALL SELECT USERID, USERNAME FROM OLD_TEMP_ORDER WHERE USERID = '10120110514052' UNION ALL SELECT USERID, USERNAME FROM OLD_TEMP_ORDER WHERE USERID = '10120110514051'
SELECT * FROM OLD_TEMP_ORDER WHERE USERID IN ('10120110514053', '10120110514052', '10120110514051');