61,655
社区成员




select * from(
(select top 5 * from table)
union all
(select top 5 * from table order by id DESC)
) as T
select * from(
(select top 5 * from table)
union all
(select top 5 * from table order by id DESC)
)
select * from(
(select top 5 * from table)t
union all
(select top 5 * from table order by id DESC)a
)
with mytable as
(
select top 5 * from table order by id
union
select top 5 * from table order by id DESC
)
select * from mytable
SELECT * FROM
(select top 5 * from tests order by id )x
UNION ALL
SELECT * FROM
(select top 5 * from tests order by id desc)x