select * from Lian_WeiboMessage where MessageID in(159826,159818,159755,159753,159752) order by charindex(','+convert(varchar,MessageID)+',',',159826,159818,159755,159753,159752,')
sql中用in查询的结果按查询条件顺序输出写法
最新推荐文章于 2024-02-28 17:51:55 发布
select * from Lian_WeiboMessage where MessageID in(159826,159818,159755,159753,159752) order by charindex(','+convert(varchar,MessageID)+',',',159826,159818,159755,159753,159752,')