select * from A order by
case Name when 'wind' then 1
When 's' then 2
when 't' then 3
end ASC
就是在Order by 后面加个case when
转载于:https://www.cnblogs.com/windstore/archive/2009/10/13/1582311.html
转载于:https://www.cnblogs.com/windstore/archive/2009/10/13/1582311.html