title: Sql Query to find A series of dates that occur within 5 minutes of each other?
body: <p>This is Sql Server 2008. I've got a set of data that looks something like this:</p>
  
  <pre><code>Table UserAchievement
     id
     userId
     achievementId
     completedDate
  </code></pre>
  
  <p>When a user earns an award, the award and user is logged along with a date. What I'd like is a query that finds a set of 3 achievements that were earned within 5 minutes of each other by the same user. Any thoughts on how to accomplish this?</p>
  
  <p>Thanks In Advance-</p>
  
  <p>Chu</p>