如果要求第8行的結果

來源: 於 2004-01-12 10:45:00 [舊帖] [給我悄悄話] 本文已被閱讀：次

SELECT * FROM
(SELECT TOP 1 * FROM
(SELECT TOP 8 * FROM pubs..authors
ORDER BY au_id) AS t1
ORDER BY au_id DESC) AS t2
ORDER BY au_id



--文學城www.wenxuecity.com--