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 朱小勇阅读(435) 评论(0) 收藏举报