作用:用于连接两个结果,注意两个表属性必须相同
SELECT TOP 1 * FROM RoadCheckData ORDER BY ID DESC
UNION ALL
SELECT TOP 1 * FROM RoadCheckData ORDER BY ID ASC
作用:用于连接两个结果,注意两个表属性必须相同
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