title: LINQ to SQL Every Nth Row From Table
body: <p>Anybody know how to write a LINQ to SQL statement to return every nth row from a table?  I'm needing to get the title of the item at the top of each page in a paged data grid back for fast user scanning.  So if i wanted the first record, then every 3rd one after that, from the following names:</p>
  
  <p><strong>Amy</strong>, Eric, Jason, <strong>Joe</strong>, John, Josh, <strong>Maribel</strong>, Paul, Steve, <strong>Tom</strong></p>
  
  <p>I'd get Amy, Joe, Maribel, and Tom.</p>
  
  <p>I suspect this can be done... LINQ to SQL statements already invoke the ROW_NUMBER() SQL function in conjunction with sorting and paging. I just don't know how to get back every nth item.  The SQL Statement would be something like <code>WHERE ROW_NUMBER MOD 3 = 0</code>, but I don't know the LINQ statement to use to get the right SQL.</p>