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

Home -> Community -> Usenet -> c.d.o.misc -> order by question

order by question

From: <h0444vcs_at_rz.hu-berlin.de>
Date: Mon, 05 Jul 1999 16:11:24 GMT
Message-ID: <7lqlf5$mpg$1@nnrp1.deja.com> 





Dear Readers,



I have the following sql statement



select distinct a.columname, count(a.columname)
from  ...


where ...


group by a.columname



the result is then displayed and ordered by a.columname,
but I want to display the result of the query ordered by



count(a.columname) desc



How does it work in oracle ?



Many thanks in advance !



Markus Banach




Sent via Deja.com http://www.deja.com/



Share what you know. Learn what you don't.
Received on Mon Jul 05 1999 - 11:11:24 CDT












Original text of this message













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