2 个解决方案
#1
order by case when col = 3 then 0 else 1 end ,othercol
#2
order by (case when id= 3 then null else id end)
#1
order by case when col = 3 then 0 else 1 end ,othercol
#2
order by (case when id= 3 then null else id end)
order by case when col = 3 then 0 else 1 end ,othercol
order by (case when id= 3 then null else id end)
order by case when col = 3 then 0 else 1 end ,othercol
order by (case when id= 3 then null else id end)