select by paging

• ashkan sirous

  SSCrazy

  Points: 2733

  More actions

  June 20, 2011 at 11:33 pm

  #389795

  Hi dudes,

  I want to select my data by paging, I mean I want to select first top 10 (records 0 to 10) then second top 10 (records 10 to 20) ,etc from a query.

  How can I do that?

  Best Regards,
  Ashkan

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  June 21, 2011 at 2:05 am

  #1341676

  This great article by Paul White will help you:

  http://www.sqlservercentral.com/articles/paging/69892/

  -- Gianluca Sartori

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  June 21, 2011 at 9:37 am

  #1341919

  Cool article. I'll be interested to see how the new ORDER BY...OFFSET in Denali stacks up against Paul's technique.

  http://msdn.microsoft.com/en-us/library/ms188385(v=sql.110).aspx

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato