1. c2列的数据按'4','1','2'的指定顺序排序
(1) 使用union
select * from t_orderby where c2='4' union all select * from t_orderby where c2='1' union all select * from t_orderby where c2='2'
(2) charindex
select * from t_orderby order by charindex(c2,'4,1,2')
(3) case when
select * from t_orderby order by case when c2='4' then 1 when c2='1' then 2 when c2='2' then 3 end,c1 desc
2. 随机排序
(1) 要求c2='4'排第一行,其他的行随机排序
select * from t_orderby order by case when c2='4' then 1 else 1+rand() end
(2) 所有行随机排序
select * from t_orderby order by newid()
(3) 随机取出第一行
select top 1 * from t_orderby order by newid()
3. 要求列c3中数据,先按第一个字符排序,再按第二个字符排序
select * from t_orderby order by left(c3,1),ASCII(substring(c3,2,1))