title: SQL ROW_NUMBER with INNER JOIN
body: <p>I need to use ROW_NUMBER() in the following Query to return rows 5 to 10 of the result. Can anyone please show me what I need to do? I've been trying to no avail. If anyone can help I'd really appreciate it.</p>
  
  <pre><code>SELECT * 
  FROM   villa_data 
         INNER JOIN villa_prices 
           ON villa_prices.starRating = villa_data.starRating 
  WHERE  villa_data.capacity &gt;= 3 
         AND villa_data.bedrooms &gt;= 1 
         AND villa_prices.period = 'lowSeason' 
  ORDER  BY villa_prices.price, 
            villa_data.bedrooms, 
            villa_data.capacity 
  </code></pre>