Not familiar with teradata, but that looks like the equivalent of select a, b, c from table where somedate between somebegin and someend and someotherdate = (s

Not familiar with teradata, but that looks like the equivalent of select a, b, c from table where somedate between somebegin and someend and someotherdate = (select max(someotherdate) from table group by a, b) which will work in all sqls. My point being, the advanced features make life nice, but are by no means necessary. (would be more efficient as a join, but not sure if joining on subtables is always supported...)