方法一:利用order by+case when
select year,country,product,profit from sales
order by year,case when country='CHIAN' then 1 when country='US' then 2 end
方法二:利用order by+charindex
select year,country,product,profit from sales
order by year,charindex(country,'CHINA,US')