可以用case when做一个列,然后根据这个列来排序,下面给出代码
select *,(case id when 19 then '1' else '2' end) as 'abc' from table order by abc
可以用case when做一个列,然后根据这个列来排序,下面给出代码
select *,(case id when 19 then '1' else '2' end) as 'abc' from table order by abc
转载于:https://www.cnblogs.com/zhuxiaojie/p/4724884.html