group by sorting

From: Bowes, Chris <Chris.Bowes_at_kosa.com>
Date: Tue, 17 Oct 2000 16:52:10 -0400
Message-Id: <10652.119545@fatcity.com>

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_at_Kosa.com

------_=_NextPart_001_01C0387C.1FE26AEA
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>group by sorting</TITLE>
</HEAD>
<BODY>

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


</BODY>
</HTML>
Received on Tue Oct 17 2000 - 15:52:10 CDT