ENXF NET
Administrator
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P.S Member
S.V.I.P Member
V.I.P Member
Collaborate
Registered
- Joined
- Nov 13, 2018
- Messages
- 26,822
- Points
- 823
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...