group data by 6 months [message #420501] |
Sun, 30 August 2009 22:19 |
ajitpal.s
Messages: 204 Registered: November 2006
|
Senior Member |
|
|
Hi,
Actually im performing mass update to a table, due to the size of the table, i plan to do it on incremental basis.
Issuing the following query allows me to group data by month-yy
select to_char(nvl(INVOICE_DATE,'31-Dec-9999'),'MON-YY'),count(*)
from deliver_org
group by to_char(nvl(INVOICE_DATE,'31-Dec-9999'),'MON-YY')
Is there any way i could group by on an interval of six months, rather than monthly?
[Updated on: Sun, 30 August 2009 23:22] by Moderator Report message to a moderator
|
|
|
|
|
|