Hi
Thank you for reading my post.
is there any way to count total records in each group of records when using "group by" command ?
for example i need to find how much people log in each hour of a day.
in this case i can use group by to group the record based on hour field and then use count to find how much people log in in each hour out of 24 :-) .
please tell me if my design is not correct.

BTW :
I get one field for each element of Data time , is it a good design ? i have these fields for year , Month , Day , Hour , minutes , seconds . is it good or i can use a dateTime field and sql let me to access each element in datetime field ?)


Reply via email to