title: Retrieving only the sixth and seventh matching results in a Rails table
body: <p>I am working on a Rails app, and I am hitting a roadblock: I need to return several items in a table that are, say, the 6th-8th matching items. Ironically, Rails has a <a href="http://api.rubyonrails.org/classes/ActiveRecord/FinderMethods.html#method-i-find_nth" rel="nofollow">helper method</a> shown here for <code>.first</code> through <code>.fifth.</code> </p>
  
  <p>My question is: how can you find these results when the n you are searching for is only 6,7,8 and so on without calling all of the 1st through 8th items?</p>
  
  <p>Here's why I am doing this. I am making a home page for a blog. At the top, I want to show the 5 most recent posts (which will be shown with an image). Underneath them, I want to show an additional three links to posts as text. </p>
  
  <p>Currently, I am doing the first part fine. In my <code>blog.controller.rb</code>: </p>
  
  <pre><code>    @posts = Post.order('created_at DESC').first(5)
  </code></pre>
  
  <p>I then iterate through Posts in the view, and that shows my first five most recent results. I now want to show the 6th-8th, and I will try and store them in a new method. I change the controller to: </p>
  
  <pre><code>    @posts = Post.order('created_at DESC').first(5)
      @texts = Post.order('created_at DESC').limit(8) 
  </code></pre>
  
  <p>This returns the 8 most recent posts instead of, say, just the 8th. </p>
  
  <p>Is it possible for me to limit <code>@texts</code> to show only the matching 6th, 7th, and 8th results? </p>