UNION

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

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

原文地址:https://www.cnblogs.com/judes/p/9222872.html