How to Convert Dates in One Group into An Interval
We have a database table TBLTEST. Below is part of its data: The data is ordered by date. We are trying to group rows by the first five columns, convert dates in each group into an interval, and record the ending date of the last record as the infinite date 99991230. Below is the desired…