GROUP by distinction...

[Anon]

okie dokie...
Here is my query
SELECT count(*),TIMESTAMP,status FROM mini_single WHERE TO_DAYS(NOW()) - TO_DAYS(TIMESTAMP) <= 7 && site='xxxxxxxxx' GROUP by TIMESTAMP ORDER by TIMESTAMP;

this produces many results like
| Count | TIMESTAMP | STATUS |
| 1 | 20020328105410 | 0 |
| 1 | 20020328105813 | 0 |
| 1 | 20020328105938 | 0 |
| 1 | 20020328110039 | 0 |
| 1 | 20020328110053 | 0 |
| 1 | 20020328112246 | 0 |
| 1 | 20020328112340 | 0 |
| 1 | 20020328112439 | 0 |
| 1 | 20020328112733 | 1 |
| 1 | 20020328112802 | 1 |

Is it possible to modify the above query to output a subsection of these results..
e.g. Grouped by hour .. within the same query .. so the results would be

| Count | TIMESTAMP | STATUS |
| 3 | 20020328100001 - 20020328110000| 0 |
| 5 | 20020328110001 - 20020328120000| 0 |
| 2 | 20020328110001 - 20020328120000| 1 |

If this makes sense to you please reply...

Cheers
Carl

[Anon]

I sorted it eventually !RTFM! doh! SQL below..
SELECT count(*),DAYOFYEAR(TIMESTAMP) as TS2,status FROM mini_single WHERE TO_DAYS(NOW()) - TO_DAYS(TIMESTAMP) <= 7 && site='xxxxxxxxx' GROUP by TS2,status ORDER by TIMESTAMP;