SQL用了Union后的排序问题
select * from (select userid from userTable where userid in (201,202)Unionselect userid from userTable where userid in (101,102,301,302)) as aorder by userid答案补充select userid from (select 1 as aa,userid from test where userid in (201,202) Unionselect 2 as aa,userid from test where userid in (101,1...全部
select * from (select userid from userTable where userid in (201,202)Unionselect userid from userTable where userid in (101,102,301,302)) as aorder by userid答案补充select userid from (select 1 as aa,userid from test where userid in (201,202) Unionselect 2 as aa,userid from test where userid in (101,102,301,302)) as TableTemporder by aa,userid答案补充如果你需要第一个SELECT的东东排在第二个之上,那就可以像我这样,你自己加一个顺序列。
收起