Archives of the TeradataForum

Message Posted: Wed, 25 May 2011 @ 10:11:36 GMT

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

Alan,

Please use the following query, hope this helps!

     SELECT

      field1
     ,field2
     ,field3
     ,MIN(start_date) OVER
     (
        PARTITION BY Field1
              ,field2
              ,field3
        ORDER BY ''
     )
     ,MAX(end_date) OVER
     (
        PARTITION BY Field1
              ,field2
              ,field3
        ORDER BY ''
     )
     FROM < Table Name >

     QUALIFY

        ROW_NUMBER() OVER

     (
        PARTITION BY Field1
              ,field2
              ,field3
        ORDER BY ''
     ) = 1

Warm Regards,

Shamim

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