Archives of the TeradataForum
Message Posted: Thu, 27 Jun 2013 @ 20:15:37 GMT
This following code returned what I was after.
, (admit_date ?- max(disch_date) over (partition by pt order by admit_date rows between 1 preceding and 1 preceding)) disch_admit
Gerald "Jerry" Fleury
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|