Subject Re: Is it possible to do this with window function?
>By what logic do you arrive at this result?

I don't know if I can explain it any better. I want to find "clusters" of "A", "B", "C" and so on, group them into one row, get the starting date from first found row and ending date from the last found row in cluster.