title: Teradata equivalent for lead and lag function of oracle
body: <p>I have been working ot see the equivalent function for Oracle lead and lag function.</p>
  
  <p>The oracle lead would look like</p>
  
  <pre><code>LEAD(col1.date,1,ADD_MONTHS(col1.DATE,12)) 
  OVER(Partition By tab.a,tab.b,tab.c Order By tab.a)-1 END_DATE
  
  LAG(col1.DATE + 7,1,col1.DATE-1) 
  OVER(partition by tab.a,tab.b Order By tab.b) LAG_DATE
  </code></pre>
  
  <p>Any better idea</p>