Archives of the TeradataForum

Message Posted: Sun, 17 Oct 2004 @ 19:21:49 GMT

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

Sampath,

how is the order in your example data achieved and is this the way it should be evaluated? Order by prty_id, D1, Own_cd??

Ulrich

     Prty_id   Own_cd    D1      D2
     111       oc1        1       3
     111       oc1        4       7
     111       oc1        8      10
     111       oc2       11      20
     111       oc1       21      50
     111       oc1       51      60
     111       oc2       61      70
     111       oc2       71      80

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