Re: group by sorting

From: Tim Sawmiller <sawmillert_at_state.mi.us>
Date: Wed, 18 Oct 2000 07:44:17 -0400
Message-Id: <10653.119620@fatcity.com>

I *think* you can have an order by clause along with a group by clause. = Try it and let us know. :-)

>>> Chris.Bowes_at_kosa.com 10/17/00 06:22PM >>>
I have looked in a couple manuals for this but have not found it. When doing a group by, a sort is done on the data. Is there anyway to specify a descending order for that sort? It is defaulted to ascending. Is there a way of overriding that? I told the developer that she should put it into = a
subquery but the query itself (all 3 pages) is already complex enough. = Any
ideas? Thank you in advance.

--Chris
Chris.Bowes_at_Kosa.com=20 Received on Wed Oct 18 2000 - 06:44:17 CDT