sql 查询第一条记录，和最后一条记录。解决方案

SELECT * FROM (select top 1 * from tb order by id )xUNION ALL SELECT * FROM (select top 1 * from tb order by id desc)x
------解决方案--------------------
top
和排序就可以了
------解决方案--------------------
哦
------解决方案--------------------
探讨

select top 1 * from tb order by id
select top 1 * from tb order by id desc


------解决方案--------------------
select top 1 * from tb order by id  
select top 1 * from tb order by id desc