select top 4 from (select * from (select top 5 * from t_table order by id) order by id desc)--先取前五条,按降序排列,然后拿到前四条id= 5,4,3,2
union
select top 4 from (select * from (select top 5 * from t_table order by id desc) order by id)--再取后五条,按升序排列,拿到前四条,即id=5,6,7,8
select top 4 from (select * from (select top 5 * from t_table order by id) order by id desc)--先取前五条,按降序排列,然后拿到前四条id= 5,4,3,2
union
select top 4 from (select * from (select top 5 * from t_table order by id desc) order by id)--再取后五条,按升序排列,拿到前四条,即id=5,6,7,8
select top 4 from (select * from (select top 5 * from t_table order by id) order by id desc)--先取前五条,按降序排列,然后拿到前四条id= 5,4,3,2
union
select top 4 from (select * from (select top 5 * from t_table order by id desc) order by id)--再取后五条,按升序排列,拿到前四条,即id=5,6,7,8