SELECT * ,
ROW_NUMBER() OVER ( ORDER BY ffavoriteid ) AS num
FROM V_EBFavorite_Transport
WHERE FStatus IN ( 2, 1, 4 )
ORDER BY CHARINDEX(RTRIM(CAST(FStatus AS VARCHAR(30))), ‘2, 1, 4‘)
原文：http://www.cnblogs.com/FFRDXRQ/p/7008141.html