difficult select- question
From: Andreas Mosmann <mosmann_at_expires-31-10-2009.news-group.org>
Date: Mon, 26 Oct 2009 13:08:52 +0100
Message-ID: <1256558932.12_at_user.newsoffice.de>
Hi ng,
Date: Mon, 26 Oct 2009 13:08:52 +0100
Message-ID: <1256558932.12_at_user.newsoffice.de>
Hi ng,
I hope, there is someone with a good idea concerning the following question:
There is a sorted Table (or view) like the following:
F1|F2|F3|F4 AA|BB|10|20 AA|BB|20|30 AA|BB|40|50 AA|BB|50|60 AA|BB|60|70 AA|CC|70|80 AA|CC|80|90
As you can see there are some rows, that are connected by F3=prior F4, but there are leaks too. I need a result as the following:
AA|BB|10|30|2 parts AA|BB|40|70|3 parts AA|CC|70|90|2 parts
I know it is easy to solve by programming.
I think it is possible to do this with inline view and hierarchical
query.
I can imagine a way by select min(F3), max(F4) ... where exists (enough
connecting data in the middle).
But what is the best (SQL-)way to solve this? (There actually are about
15000 lines, the estimated result probably should not have more than 100
lines)
I could do it by PL/SQL, but I am interested in SQL, if exists
Andreas Mosmann
-- wenn email, dann AndreasMosmann <bei> web <punkt> deReceived on Mon Oct 26 2009 - 07:08:52 CDT