Skip to content

Instantly share code, notes, and snippets.

@New0

New0/last.sql

Created September 10, 2020 09:53
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save New0/fa6954a280636545d0824e13c5509a69 to your computer and use it in GitHub Desktop.
Save New0/fa6954a280636545d0824e13c5509a69 to your computer and use it in GitHub Desktop.
Download ZIP
last 30 days distinct accounts using BETWEEN
Raw
last.sql
SELECT DISTINCT
account
FROM
messages t
WHERE
t.created_at BETWEEN DATE_SUB(NOW(), INTERVAL 30 DAY) and NOW()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment