Advanced Search

SQL GRouping & Between example

/ Published in: SQL
Save to your folder(s)
grouping using between and date

Expand | Embed | Plain Text

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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.