一个取数据集中指定一段记录的简单方法

时间：2010-11-13 来源：飞云

代码

CREATE TABLE [dbo].[News](
    [NewsID] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
    [NewsTypeID] [int] NULL,
    [NewsTitle] [nvarchar](50),
    [PeopleID] [int] NULL,
    [NewsContent] [nvarchar](max),
    [NewsHot] [int] NULL,
    [NewsClick] [int] NULL,
    [NewsAddTime] [datetime] NULL,
    [IsCheck] [int] NULL,
    [CheckPeople] [int] NULL,
    [CheckTime] [datetime] NULL)

现在我们要做的就是取出记录的第10条到第20条：



SELECT TOP   10  *  FROM  News   WHERE   NewsID NOT IN   
(SELECT   TOP   10   NewsID     FROM   News ORDER   BY   NewsID   DESC )   
ORDER   BY   NewsID   DESC