现在想查第10000到10050条SELECT TOP 50 *
FROM table
WHERE (ID >
(SELECT MAX(id)
FROM (SELECT TOP 10050 id
FROM table
ORDER BY id) AS T))
ORDER BY ID
FROM table
WHERE (ID >
(SELECT MAX(id)
FROM (SELECT TOP 10050 id
FROM table
ORDER BY id) AS T))
ORDER BY ID
FROM table
WHERE (ID >
(SELECT MAX(id)
FROM (SELECT TOP 10000 id
FROM table
ORDER BY id) AS T))
ORDER BY ID
FROM table
WHERE ID >(SELECT MAX(id)
FROM (SELECT TOP 10000 id
FROM table
ORDER BY id) as tt)