Hi,
Please show how exactly resultset should be because i now do not understand
your needs. Query return path and return in order a before b what more?
Regards,Karol Bieniaszewski
-------- Oryginalna wiadomość --------Od: "josef.gschwendt...@quattro-soft.de
[firebird-support]" <firebird-support@yahoogroups.com> Data: 07.11.2017 08:53
(GMT+01:00) Do: firebird-support@yahoogroups.com Temat: Re: [firebird-support]
Sorting-Problem on recursive query (window functions)
Hi,
thank you for your ideas.
But I think your solution would only work if the anchor query would select
treemembers of level 1.
Whereas my query starts with "where Green =
'Yes'" and these elements are in different levels.
I have read that this should be possible with "window functions", but I can't
find an example which works for me.
Regards,
Josef
