[SQL] 让特定的数据 排在最前

-- 方法一
select * from tableName  ORDER BY  case when columnName='张三' then 0  else 1 end  asc


-- 方法二
select * from tableName  where columnName ='张三' union all select * from tableName  where columnName <>'张三'