RE: group by sorting

From: Amar Kumar Padhi <TS2017_at_emirates.com>
Date: Wed, 18 Oct 2000 08:50:41 +0400
Message-Id: <10652.119588@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_01C038BE.F7AC4DA0
Content-Type: text/plain;

charset="iso-8859-1"

you can use 'Order by' clause at the end of your sql like

order by 1 desc.

Thanks,
Amar
00-971-50-7883254
ts2017_at_emirates.com <mailto:ts2017_at_emirates.com> amar_padhi@ <mailto:amar_padhi_at_hotmail.com> hotmail.com amar_padhi@ <mailto:amar_padhi_at_musclemail.com> musclemail.com

-----Original Message-----
From: Bowes, Chris [mailto:Chris.Bowes_at_kosa.com] Sent: Wednesday, October 18, 2000 2:23 AM To: Multiple recipients of list ORACLE-L Subject: 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_at_Kosa.com

------_=_NextPart_001_01C038BE.F7AC4DA0
Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<TITLE>group by sorting</TITLE>
<META content='"MSHTML 4.72.3713.2800"' name=GENERATOR>
</HEAD>
<BODY>
<DIV> </DIV>
<DIV><SPAN class=637314504-18102000><FONT color=#0000ff face="Courier New"
size=2>you can use 'Order by' clause at the end of your sql like</FONT></SPAN></DIV>
<DIV><SPAN class=637314504-18102000><FONT color=#0000ff face="Courier New"
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=637314504-18102000><FONT color=#0000ff face="Courier New"
size=2>order by 1 desc.</FONT></SPAN></DIV>
<P><FONT color=#000000 face="Courier New" size=2>Thanks,</FONT> <BR><B><FONT

color=#000000 face="Courier New" size=2>Amar</FONT><I></I></B> <BR><FONT 
color=#008080 face="Courier New" size=2>00-971-50-7883254</FONT> <BR><FONT 
color=#008080 face="Courier New" size=2><A

href="mailto:ts2017_at_emirates.com">ts2017_at_emirates.com</A></FONT> <BR><FONT color=#008080 face="Courier New" size=2><A

href="mailto:amar_padhi_at_hotmail.com">amar_padhi@</FONT><B><FONT color=#008080 
face="Courier New" size=2>hot</FONT></B><FONT color=#008080 face="Courier New" 
size=2>mail.com</FONT></A> <BR><FONT color=#008080 face="Courier New" size=2><A 
href="mailto:amar_padhi_at_musclemail.com">amar_padhi@</FONT><B><FONT color=#008080 
face="Courier New" size=2>muscle</FONT></B><FONT color=#008080 
face="Courier New" size=2>mail.com</FONT></A> </P>

<DIV> </DIV>
<BLOCKQUOTE>

<DIV class=OutlookMessageHeader><FONT face="Times New Roman" size=2>-----Original Message-----<BR><B>From:</B> Bowes, Chris [mailto:Chris.Bowes_at_kosa.com]<BR><B>Sent:</B> Wednesday, October 18, 2000 2:23 AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> group by sorting<BR><BR></FONT></DIV> <P><FONT face=Arial size=2>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.</FONT></P><BR>
<P><FONT face=Arial size=2>--Chris</FONT> <BR><FONT face=Arial size=2>Chris.Bowes_at_Kosa.com</FONT> </P></BLOCKQUOTE></BODY></HTML> Received on Tue Oct 17 2000 - 23:50:41 CDT