Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 11 Sep 2012 @ 17:37:09 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Grouping the data and pulling the max value when different windows exist
From:   sivaram nelluri

Hello gurus,

My data looks as follows:

     Key 1 , Value1, Time1
     Key1 , Value1, time2
     Key1, Value2, Time 3
     Key1, Value2, time4
     Key1, Value1, time 5
     Key1, Value1, Time6
     Key1, Value2, Time7

So the above data should yield me as follows

     Key1, Value1, Time1, Time2
     Key1, Value1, Time2, Time2
     Key1, Value2,Time3, Time4
     Key1, Value2, Time4, Time4
     Key1, Value1, Time6, Time7
     Key1, Value1,Time7, Time7

We have to identify the groups in sequnce.

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023