sql server 自定义排序

方法一：利用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