|
View previous topic :: View next topic
|
| Author |
Message |
tecnokrat
Warnings : 1
Active User
Joined: 22 May 2009
Posts: 160
Location: Bangalore
|
|
|
|
Hi ,
i have a requirement to get the count of the rows for whole 30 days of a month.
Below is my query to get the results for one particular day
| Code: |
SELECT COUNT(*)
FROM TABLE1
WHERE
TAB1_COL1 = 'A'
AND TAB1_MODULE = 'PGM1'
AND TAB1_ERROR = 'CICS'
AND TAB1_CRTN_TS < '2010-09-02-00.00.00.000000'
AND TAB1_CRTN_TS >= '2010-09-01-00.00.00.000000' ; |
in the above query can i get a function that retrieves the details of the day1 to day 30 by tweaking it.
Please help me. |
|
| Back to top |
|
 |
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2481
Location: @my desk
|
|
|
|
| Quote: |
| for whole 30 days of a month |
Is that for current month? Or something else?? |
|
| Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
|
|
|
|
do you mean total of 30 days or count(*) for each day ?
| Code: |
select date(TAB1_CRTN_TS) ,count(*)
...
group by date(TAB1_CRTN_TS) |
|
|
| Back to top |
|
|
tecnokrat
Warnings : 1
Active User
Joined: 22 May 2009
Posts: 160
Location: Bangalore
|
|
|
|
| thanks i got the output ... |
|
| Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2481
Location: @my desk
|
|
|
|
| Good to know you figured it out. Do you mind sharing the solution? |
|
| Back to top |
|
|
|
|
