Re: Nested sort
From: Mikito Harakiri <mikharakiri_nospaum_at_yahoo.com>
Date: 28 Sep 2005 17:01:52 -0700
Message-ID: <1127948996.235292.106890_at_g14g2000cwa.googlegroups.com>
Date: 28 Sep 2005 17:01:52 -0700
Message-ID: <1127948996.235292.106890_at_g14g2000cwa.googlegroups.com>
Bob Stearns wrote:
> Hugo Kornelis wrote:
>
> > On Wed, 28 Sep 2005 18:00:45 -0400, Bob Stearns wrote:
> >
> > (snip)
> >
> >>is there (relatively) easy
> >>way to present the data in a sorted manner?
> >
> >
> > Hi Bob,
> >
> > Sure!
> >
> > SELECT NAMEX
> > FROM IS3.LOCATIONS
> > WHERE whatever your current where clause is
> > ORDER BY NAMEX
> >
> > Best, Hugo
> That is too easy, I know how to do that. I want a nested sort. All the
> first level locations in order(states), the second level within them
> sorted(sites), the third level within them sorted (buildings), etc.
Sort by materialized path?
CA/SACRAMENTO/Gov.Bld.1
Received on Thu Sep 29 2005 - 02:01:52 CEST