title: SQL Server - Select all top of the hour records
body: <p>I have a large table with records created every second and want to select only those records that were created at the top of each hour for the last 2 months. So we would get 24 selected records for every day over the last 60 days</p>
  
  <p>The table structure is Dateandtime, Value1, Value2, etc </p>
  
  <p>Many Thanks</p>