Why the one inside does not do anything? It won't be executed?
Best,
Jing
On Tue, Nov 5, 2013 at 8:52 AM, Albe Laurenz <laurenz.albe@xxxxxxxxxx> wrote:
Jing Fan wrote:I mean the one outside the CTE.
> I have two group operations.
>
> One is inside the CTE ( union
> select src_id, dest_id, min(dist) ),
> another is outside the CTE.
> Do you mean that even the grouping inside the CTE will be calculated only after the CTE has been
> calculated?
The one inside does not do anything at all, you could omit it.
Yours,
Laurenz Albe
