M

SQL for largest time difference between consecutive posts

  • Thread starter Thread starter Mouth
  • Start date Start date

Visitor Greeting

Welcome to NullWarehouse.com... We are currently seeking Mod's and Contributors. If you wish to apply for a Mod position then please click on Members dropdown arrow, then click on Staff App and fill it out completely and submit it. If you want to be a Contributor then start contributing and we will have our eye on you and take notice, something great could come of it.

  • We have redone the forum. If you notice any issues or errors please open a Support Ticket under the Members dropdown and let us know.
M

Mouth

Guest

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...
 
Similar content Most view View more
Back
Top Bottom