--降序 select top 50 * from tablename order by id desc--升序 select top 50 * from tablename order by id
哦。是一条语句取出来是吧? 呵呵。不好意思。图快,所以理解错了。再贴```select * from (select top 50 * from tablename order by id desc)a union all select * from (select top 50 * from tablename order by id)b
select top 50 * from tablename order by id desc--升序
select top 50 * from tablename order by id
呵呵。不好意思。图快,所以理解错了。再贴```select * from
(select top 50 * from tablename order by id desc)a
union all
select * from
(select top 50 * from tablename order by id)b