title: How to extract the nth row of a sql statement?
body: <p>I am trying to extract the nth row of an SQL statement (not the nth row of a table).
  Is there an easy way to run a query and read values from specific rows. </p>
  
  <p>I have tried something similar to this but it does not work since rownum tells me what nth record it is in the table.</p>
  
  <pre><code>SELECT * FROM (
      SELECT
          ROW_NUMBER() OVER(ORDER BY RewardID ASC) AS rownumber,
          RewardID,
          Name,
          Description,
          Image,
          RewardType,
          price
      FROM
          Reward
  ) AS num 
  WHERE
      RewardType = 'Electronics' and rownum = 2
  </code></pre>