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

Home -> Community -> Usenet -> c.d.o.server -> count by month

count by month

From: Ben <bthomas_at_trey-industries.com>
Date: 30 Aug 2001 05:14:02 -0700
Message-ID: <991ee5b0.0108300414.d6f2e31@posting.google.com>


I have a table that has

sale (number)
saledate (date)


I want to write a query that will count the sales by month and return

sale saledate

12     Januray
33     February
2      March


is there a way to do that on Oralce 7.3? Received on Thu Aug 30 2001 - 07:14:02 CDT

Original text of this message

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