Easy Paging - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Easy Paging

Author

Topic

SJ
Starting Member

2 Posts

Posted - 2002-05-19 : 05:16:49

1st page
------
Select TOP 10 ID,Title From MyTabel
Where ID Not in (
Select Top 10 ID,Title From MyTabel Order By ID
)
Order By ItemDate

2nd page
------
Select TOP 10 ID,Title From MyTabel
Where ID Not in (
Select Top 10 ID,Title From MyTabel Order By ID
)
Order By ID

3rd page
-------
2nd page
------
Select TOP 10 ID,Title From MyTabel
Where ID Not in (
Select Top 20 ID,Title From MyTabel Order By ID
)
Order By ID

Nth page
------
Select TOP 10 ID,Title From MyTabel
Where ID Not in (
Select Top (Page-1)*10 ID,Title From MyTabel Order By ID
)
Order By ID

test it on MsSQL:


use tempdb

Go

If Exists (select name from 
 sysobjects where 
  name=N'pagging' and type='U')
   Drop Table pagging
GO

Create Table pagging( 
id int default 1
)

GO

Declare @N int

Set @N=1

While @N<=100
 begin
  insert into pagging values(@N)
  set @N=@N+1
 end 

GO
-- page#1
Select TOP 10 ID from pagging Where Not ID in
  (Select TOP 0 ID from pagging Order by ID)
Order by ID

-- page#2
Select TOP 10 ID from pagging Where Not ID in
  (Select TOP 10 ID from pagging Order by ID)
Order by ID

-- page#3
Select TOP 10 ID from pagging Where Not ID in
  (Select TOP 20 ID from pagging Order by ID)
Order by ID

and
tell me what do you thing?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources