查询从第二条到第七条记录方法

方法1
select top 6 ArticleID,Title
from Article_List
 where EXISTS
(
select top 1 ArticleID,Title from Article_List  order by AddTime Desc
) order by AddTime Desc

方法2
select top 6 * from [hnep_hb_tousu]
where id not in (select top 1 id from [hnep_hb_tousu] order by id asc) order by addtime desc

posted @ 2007-08-27 16:20  生活无限  阅读(312)  评论(0编辑  收藏  举报