Grouping

[Guest]

Hi

I have a table that shows people Evenst and hour of event hour and I want a
Select query which show total number of people for any given hour regardless
of event.

Ie have
Person Event hour
bob started 9
bob ended 9
clive started 9
bob completed 10

would return
2 persons at 9
1 persons at 10
i can only get it to group events ie
2 Started at 9
1 Ended at 9
1 Completed at 9
Help

 

[Guest]

Try and use two quries
1. group by on person and hour
2. second query based on the first one, have both field in group by and the
hour again for count.