方法一：利用order by+charindex
SELECT country FROM table_name ORDER BY CHARINDEX(country,'China,USA,India')
方法二：建立臨時表
select row_number() over(order by b.num) as row_number, a.* from table_1 a, table_2 b where a.column=b.column
方法一：利用order by+charindex
SELECT country FROM table_name ORDER BY CHARINDEX(country,'China,USA,India')
方法二：建立臨時表
select row_number() over(order by b.num) as row_number, a.* from table_1 a, table_2 b where a.column=b.column
![【釋出】App Store 預覽視訊制作總結知乎專欄：AppStore預覽視訊制作心得[圖]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)