Re: Nested sort

Gene Wirchenko wrote: 
On Wed, 28 Sep 2005 18:48:12 -0400, Bob Stearns
<rstearns1241@xxxxxxxxxxx> 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? 


Sure!

SELECT   NAMEX
FROM     IS3.LOCATIONS
WHERE    whatever your current where clause is
ORDER BY NAMEX


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. 


          order by states,sites,buildings

Sincerely,

Gene Wirchenko

Those columns dont exist in my table.
.

Relevant Pages

  • Re: Nested sort
    ... >way to present the data in a sorted manner? ... Hi Bob, ... WHERE whatever your current where clause is ... ORDER BY NAMEX ...
    (comp.databases.theory)
  • Re: Nested sort
    ... >Hugo Kornelis wrote: ... >>>way to present the data in a sorted manner? ... >> ORDER BY NAMEX ... Gene Wirchenko ...
    (comp.databases.theory)
  • Re: Nested sort
    ... way to present the data in a sorted manner? ... ORDER BY NAMEX ... Best, Hugo ... first level locations in order, the second level within them sorted, the third level within them sorted, etc. ...
    (comp.databases.theory)