Mouth
Guest
offline
Can anyone think of some SQL to answer the question of "what's the longest time between postings on a thread?"
i.e, which thread has the greatest time difference between two consecutive posts?
For example, thread x has a 18 year gap between posts 3 and 4, and thread y has a 21 year gap between posts 326 and 327 - thread y would be identified as the largest post time gap.
Continue reading...
i.e, which thread has the greatest time difference between two consecutive posts?
For example, thread x has a 18 year gap between posts 3 and 4, and thread y has a 21 year gap between posts 326 and 327 - thread y would be identified as the largest post time gap.
Continue reading...