select a.hbsz_dm,a.hbmc from dm_gy_hb a where a.xybz='Y' and a.yxbz='Y'order by case when hbsz_dm='156' then 0 else 1 end
以上sql实现指定hbsz_dm是156的排列在第一条
select a.hbsz_dm,a.hbmc from dm_gy_hb a where a.xybz='Y' and a.yxbz='Y'order by case when hbsz_dm='156' then 0 else 1 end
以上sql实现指定hbsz_dm是156的排列在第一条