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.a...@wien.gv.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 >
