comparing results
Posted: Tue Jun 02, 2009 11:55 pm
I am looking for a way to compare data in a table that stores a timestamp of when an action was accessed by a user. I am wanting to pull from the database ONLY timestamps that are atleast 15 seconds apart from eachother.
Here is a sample select statement without comparin the timestamps.
I am thinking a nested select statement should do something like this.
Here is a sample select statement without comparin the timestamps.
Code: Select all
SELECT timestamp FROM actions WHERE userid = 1