SQL GRouping & Between example

/ Published in: SQL
Save to your folder(s)

grouping using between and date

Copy this code and paste it in your HTML
  1. SELECT DATE(CreatedAt), COUNT(*) FROM gamma_wimbledon WHERE (Latitude BETWEEN '51.42361745514588' AND'51.44261323389316') AND (Longitude BETWEEN '-0.2270221710205078' AND '-0.19196033477783203') GROUP BY DATE(CreatedAt);

Report this snippet


RSS Icon Subscribe to comments

You need to login to post a comment.