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(dot)albe(at)wien(dot)gv(dot)at>wrote:
> Jing Fan wrote:
> > 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?
>
> I mean the one outside the CTE.
>
> The one inside does not do anything at all, you could omit it.
>
> Yours,
> Laurenz Albe
>