Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> group by sorting

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>

<P><FONT SIZE=3D2 FACE=3D"Arial">I have looked in a couple manuals for =
this but have not found it.&nbsp; When doing a group by, a sort is done = on the data. Is there anyway to specify a descending order for that = sort?&nbsp; It is defaulted to ascending.&nbsp; Is there a way of = overriding that?&nbsp;&nbsp; I told the developer that she should put = it into a subquery but the query itself (all 3 pages) is already = complex enough.&nbsp; Any ideas?&nbsp; Thank you in advance.</FONT></P>
<BR>

<P><FONT SIZE=3D2 FACE=3D"Arial">--Chris</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Chris.Bowes_at_Kosa.com</FONT>
</P>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US