08-27-2010, 08:07 PM
|
#1 (permalink)
|
|
The Visitor
Join Date: Aug 2010
Posts: 1
Thanks: 0
|
Query: least 15 records in the last seven days
How to make a query, if I want to find a userID who is at least 15 records in the last seven days of the table "example" field 'cID=2'.
table "example"
pID | cID | userID | rTime
1, 2, 34, 2010-11-04 16:36:29
2, 2, 27, 2010-11-04 18:45:02
...
|
|
|
|