□通用方法:(SQL 2000) 取得Order順序第N~N1筆資料 SELECT TOP 10 * FROM ( SELECT TOP 110 * FROM tb_Temp ORDER BY tb_Temp.CreateTime ) AS a ORDER BY a.CreateTime DESC