34,590
社区成员
发帖
与我相关
我的任务
分享
WITH T1 AS ( SELECT TOP 100 * FROM test WHERE begindate BETWEEN '2008-01-01 00:00:00' AND '2008-01-01 00:00:01' AND no>1000 ORDER BY begindate, no)
, T2 AS (SELECT TOP 100 * FROM test WHERE begindate > '2008-01-01 00:00:01' AND no>1000 ORDER BY begindate, no)
SELECT TOP 100 * FROM T1 UNION SELECT TOP 100 * FROM T2 ORDER BY begindate, no
SELECT TOP 100 * INTO #T1 FROM test WHERE begindate BETWEEN '2008-01-01 00:00:00' AND '2008-01-01 00:00:01' --备注:时间范围是1秒?
AND no>1000
ORDER BY begindate, no
SELECT TOP 100 * INTO #T2 FROM test WHERE begindate > '2008-01-01 00:00:01' AND no>1000
ORDER BY begindate, no
SELECT TOP 100 * FROM #T1
UNION SELECT TOP 100 * FROM #T2
ORDER BY begindate, no
DROP TABLE #T1
DROP TABLE #T2
消息 156,级别 15,状态 1,第 9 行
关键字 'UNION' 附近有语法错误。
消息 102,级别 15,状态 1,第 16 行
')' 附近有语法错误。
SELECT TOP 100 * FROM
(
SELECT * FROM
(
SELECT TOP 100 * FROM test WHERE begindate BETWEEN '2008-01-01 00:00:00' AND '2008-01-01 00:00:01' --备注:时间范围是1秒?
AND no>1000
ORDER BY begindate, no
)
UNION
SELECT * FROM
(
SELECT TOP 100 * FROM test
WHERE begindate > '2008-01-01 00:00:01' AND no>1000
ORDER BY begindate, no
)
)
ORDER BY begindate, no