Tags for preceding
How to identify and select ROW, where there was a change in value in specific column
Hello,   --My apologies for my english   Please, I'm looking for a good way, how to identify first row from behind, before change in column TYPE_CD   When you look below on examples, you will understand, what I am looking for.      -->Standalone tables (5 examples)  
Compare current row with previous NOT NULL row in Teradata.
Hi,   I need to implement a logic in which i need to compare my current row with previous NOT NULL row. I am using PRECEDING function but didn't get the desired results. Please find details below. If my source table is like Code  Id     Datetime                       Flag1 Flag2 Flag3
preceding NOT NULL
Filtering records that have overlapping dates
Hi,      I need to filter only those records in a partition that have overlapping dates. Consider the following scenario,  MBR_KEY START_DATE END_DATE 1 123 1/1/2013 9/8/2013 2 123 9/1/2013 9/8/2013 3 123 9/9/2013 10/8/2013 4 245 1/1/2013 9/8/2013 5 245 9/1/2013 9/8/2013 6 245 9/9/2013 10/8/2013
overlapping date sql preceding