Re: How to tweak hierarchial SQL queries?
From: Michael T. Boduch <mboduch_at_interaccess.com>
Date: 1995/12/01
Message-ID: <mboduch.38.0008C57D_at_interaccess.com>#1/1
Date: 1995/12/01
Message-ID: <mboduch.38.0008C57D_at_interaccess.com>#1/1
>>1. Is there any way to affect the order in which "siblings" are returned?
For
>>
>>example, we have a parent-child table containing locations. I'd like to
see
>>this result from a query:
>>
>>Arizona
>> Phoenix
>> Tempe
>>Arkansas
>> Fayetteville
>> Little Rock
>> Texarkana
>> ...
>>
>>I can't get the "states" and "cities" to come back in alphabetical order.
>There is a pseudo-column LEVEL, so ORDER BY LEVEL,name!
Which would give you:
Arizona
Arkansas
Fayetteville
Little Rock
Phoenix
Tempe
Texarkana
Somehow I don't believe that that's what's desired...
>T. Kahle, Hamburg
Received on Fri Dec 01 1995 - 00:00:00 CET