SQL2005取舍确定位置的记录

select * from(select row_number() over(order by 列1) as num, 列1,列2,列3 from 表名 ) as tempTab where num=5

例子:选取Guestbook数据表的第五条记录
SELECT???? *
FROM???????? (SELECT???? row_number() OVER (ORDER BY time) AS num, *
FROM???????? guestbook) AS tempTab
WHERE???? num = 5