作用：用于连接两个结果，注意两个表属性必须相同
SELECT TOP 1 * FROM RoadCheckData ORDER BY ID DESC
UNION ALLSELECT TOP 1 * FROM RoadCheckData ORDER BY ID ASC本文共 183 字，大约阅读时间需要 1 分钟。
作用：用于连接两个结果，注意两个表属性必须相同
SELECT TOP 1 * FROM RoadCheckData ORDER BY ID DESC
UNION ALLSELECT TOP 1 * FROM RoadCheckData ORDER BY ID ASC转载于:https://www.cnblogs.com/judes/p/9222872.html