Question

我用SQL查询出了一个表，我想让第3行的数据放在最后一行怎么做？

Answer 1

select *,(case id when (select top 1 id from yourtable where id not in (select top 2 id from yourtable)) then 1 else 0 end) as ordering from yourtable ordering by ordering

语句有点长，思路就是多增加一个排序字段，当时第三条记录时降低排序。

Answer 2

select * from ( select rownum,* from table ) a where rownum <> 3
union all
select * from ( select rownum,* from table ) a where rownum = 3

奇奇怪怪的问题