New0/last.sql

Last active September 10, 2020 09:24

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/New0/8e28c8c9ecf26656d6764d52652d4eac.js"></script>
Save New0/8e28c8c9ecf26656d6764d52652d4eac to your computer and use it in GitHub Desktop.

Download ZIP

Last 30 days Interval with comparison symbols

Raw

	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