UNION

作用:用于连接两个结果,注意两个表属性必须相同

 

SELECT TOP 1 * FROM RoadCheckData ORDER BY ID DESC
UNION ALL
SELECT TOP 1 * FROM RoadCheckData ORDER BY ID ASC

posted @ 2018-06-25 09:40  朱小勇  阅读(427)  评论(0编辑  收藏  举报