SQL> select * from regions; REGION_ID REGION_NAME
---------- -------------------------
1 Europe
2 Americas
3 Asia
4 Middle East and AfricaSQL> select id,name from
2 (
3 select region_id id,region_name name,0 seq from regions where region_id=3
4 union
5 select region_id,region_name,region_id from regions where region_id<>3
6 )
7 order by seq; ID NAME
---------- -------------------------
3 Asia
1 Europe
2 Americas
4 Middle East and Africa
---------- -------------------------
1 Europe
2 Americas
3 Asia
4 Middle East and AfricaSQL> select id,name from
2 (
3 select region_id id,region_name name,0 seq from regions where region_id=3
4 union
5 select region_id,region_name,region_id from regions where region_id<>3
6 )
7 order by seq; ID NAME
---------- -------------------------
3 Asia
1 Europe
2 Americas
4 Middle East and Africa
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货