SQL 按指定顺序进行排序

SQL语句如下：

 

select * from pdt_Music where MusicID in(1,2,3,4,5,6,7,8,9)
order by CHARINDEX(RTRIM(CAST(MusicID as NCHAR)),'5,2,8,1,3,4,6,7,9')

 

 

 

 

select * from wcm_PublishmentSystem where PublishmentSystemID in(2491,3610,2588,2629,2669)
order by charindex(','+convert(varchar,PublishmentSystemID)+',','2491,3610,2588,2629,2669')

 

 

 

 

 

 

select * from wcm_PublishmentSystem Where PublishmentSystemID IN (2491,3610,2588,2629,2669) 
order by CHARINDEX(RTRIM(CAST(PublishmentSystemID as NCHAR)),'2669,3610,2491,2588,2629')