title: Using "Rows between 1 Following and 1 Following in Teradata" to Select the next row's values
body: <p>I am trying to select the next row's value into a another column.  However, I get both the current and next value..</p>
  
  <p>The SQL query being used is the following:</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT DISTINCT
    "Title",
    "US Release Date Title",
    MAX("Title") OVER (
      PARTITION BY "Brand"
      ORDER BY "US Release Date Title" DESC, "Title" DESC
      ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING
  ) AS "Predecessor"
  </code></pre>
  
  <p>And a snippet the output from that query is this:</p>
  
  <pre><code>Call of Duty: Black Ops IIII    |  2018-10-12  |  Call of Duty: Black Ops IIII    |  2018-10-12
  Call of Duty: Black Ops IIII    |  2018-10-12  |  Call of Duty: WWII              |  2017-11-03
  Call of Duty: WWII              |  2017-11-03  |  Call of Duty: Infinite Warfare  |  2016-11-04
  Call of Duty: WWII              |  2017-11-03  |  Call of Duty: WWII              |  2017-11-03
  Call of Duty: Infinite Warfare  |  2016-11-04  |  Call of Duty: Advanced Warfare  |  2014-11-03
  Call of Duty: Infinite Warfare  |  2016-11-04  |  Call of Duty: Infinite Warfare  |  2016-11-04
  Call of Duty: Advanced Warfare  |  2014-11-03  |  null                            |  null
  Call of Duty: Advanced Warfare  |  2014-11-03  |  Call of Duty: Advanced Warfare  |  2014-11-03
  </code></pre>
  
  <p>My desired output is this:
  And a snippet the output from that query is this:</p>
  
  <pre><code>Call of Duty: Black Ops IIII    |  2018-10-12  |  Call of Duty: WWII              |  2017-11-03
  Call of Duty: WWII              |  2017-11-03  |  Call of Duty: Infinite Warfare  |  2016-11-04
  Call of Duty: Infinite Warfare  |  2016-11-04  |  Call of Duty: Advanced Warfare  |  2014-11-03
  Call of Duty: Advanced Warfare  |  2014-11-03  |  null                            |  null
  </code></pre>