- تاریخ ثبتنام
- 2020-06-26
- نوشتهها
- 21,092
- راهحلها
- 27
- پسندها
- 3,262
- امتیازها
- 113
- سن
- 27
- محل سکونت
- England
- وب سایت
- xenforo.xyz
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.
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.
