Archives of the TeradataForum

Message Posted: Wed, 24 Feb 2016 @ 20:52:29 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Johnpaul J wrote:

OLAP-time again :)

As Teradata doesn't implement LAG you have to rewrite it using MIN:

     SELECT ....
         update_time
         - MIN(update_time) -- previous update_time
           OVER (PARTITION BY Ticket_no
                 ORDER BY update_time
                 ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING) DAY(4) TO SECOND FROM tab QUALIFY
         MIN(State) -- previous State
         OVER (PARTITION BY Ticket_no
               ORDER BY update_time
               ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING) = 'need-info'
         AND State <> 'need-info'

Dieter

	<Prev	Next>		<<First	<Prev	Next>	Last>>