sql 中如何将返回的记录某一条置顶

Answer 1

将table1中id 为2的记录置顶
select * from table1
order by case when id='2' then 0 else 1 end

Answer 2

select * from table1 where id=2
union all
select * from table1 where id<>2