Message-Id: <10652.119545@fatcity.com> From: "Bowes, Chris" Date: Tue, 17 Oct 2000 16:52:10 -0400 Subject: group by sorting This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C0387C.1FE26AEA Content-Type: text/plain; charset="iso-8859-1" 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@Kosa.com ------_=_NextPart_001_01C0387C.1FE26AEA Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable group by sorting

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@Kosa.com