Skip to content

Instantly share code, notes, and snippets.

@New0

New0/last.sql

Last active September 10, 2020 09:24
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/8e28c8c9ecf26656d6764d52652d4eac to your computer and use it in GitHub Desktop.
Save New0/8e28c8c9ecf26656d6764d52652d4eac to your computer and use it in GitHub Desktop.
Download ZIP
Last 30 days Interval with comparison symbols
Raw
last.sql
SELECT DISTINCT
account
FROM
messages t
WHERE
t.created_at >= DATE_SUB(NOW(), INTERVAL 30 DAY) and t.created_at < NOW()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment