SQL查询某表，并将其中一条记录置顶或置底

[img]http://dl.iteye.com/upload/picture/pic/136627/07e163fc-744e-31e4-b2e7-8a448bb6e7c9-thumb.png[/img]

如上图将红框中的记录置底：

select * from bank order by case MiniName when 'OTH' then 0 end

结果如下：

[img]http://dl.iteye.com/upload/picture/pic/136629/a12b7c6f-3669-3ee2-ac11-eb36cf1b7362-thumb.png[/img]

置顶写法如下：

select * from bank order by case MiniName when 'OTH' then 0 else 1 end

结果如下：

[img]http://dl.iteye.com/upload/picture/pic/136631/022f7c3b-c28a-3fc2-9e05-96814feb17b0-thumb.png[/img]

更多关于 case when ...then .. else ...end 的用法：
[url]http://www.cnblogs.com/whl4835349/p/5752292.html[/url]