Re: Group by week

From: Vladimir Ivanovich <vladimiri_at_bosmedtech.com>
Date: Mon, 11 Jun 2001 16:52:44 -0400
Message-ID: <xcaV6.14$l16.1977@news.nyc.globix.net>

Fabio,

Try this:

ALTER SESSION SET NLS_DATE_FORMAT='MM-DD-YYYY' /

SELECT (HIREDATE - TO_CHAR(HIREDATE,'D')+1) AS "WEEK OF", COUNT(*) FROM EMP
GROUP BY (HIREDATE - TO_CHAR(HIREDATE,'D')+1) ORDER BY 1
/

WEEK OF COUNT(*)

---------- ----------
12-14-1980          1
02-15-1981          1
02-22-1981          1
03-29-1981          1
04-26-1981          1
06-07-1981          1
09-06-1981          1
09-27-1981          1
11-15-1981          1
11-29-1981          2
01-17-1982          1

WEEK OF      COUNT(*)
---------- ----------
04-19-1987          1
05-17-1987          1

13 rows selected.

Hope this helps,
Vladimir

"Fabio Oliveira Della Santina" <fabio.oliveira_at_edb.ericsson.se> wrote in message news:3B24B57C.67B807D8_at_edb.ericsson.se...
> Hi all,
>
> I need to build a SQL Query that group data by week, having how exit
> anything like that:
>
> 05-01-2001 -----------
> 05-08-2001 -----------
> 05-15-2001 -----------
>
> Please, anybody can help me with the group by clause ?
>
> Thanks
>
>
>
Received on Mon Jun 11 2001 - 15:52:44 CDT