JChilds Posted July 1, 2008 Share Posted July 1, 2008 I have a table with three columns: Timestamp, ID, Amount Every hour, new data is written to the table. The ID always stays the same, but the Timestamp(obviously) and Amount are changing. eg: 2008-06-24 08:00:00 1 100 2008-06-24 09:00:00 1 176 2008-06-24 08:00:00 2 120 2008-06-24 09:00:00 2 134 I want to be able to be able to retrieve all the ID's where the amount hasn't changed in the last 72 hours. I have no idea how to approach this, so if anyone could point me in the right direction, I'd appreciate it very much. Link to comment Share on other sites More sharing options...
Barand Posted July 1, 2008 Share Posted July 1, 2008 Double post - locked Link to comment Share on other sites More sharing options...
Recommended Posts