Skip to content

Instantly share code, notes, and snippets.

@kerbelp

kerbelp/redshfit_delete_old_data.sql

Created October 3, 2016 12:11
Show Gist options
  • Save kerbelp/81e96ba5e3ca8f2550814e84fe8473ce to your computer and use it in GitHub Desktop.
Save kerbelp/81e96ba5e3ca8f2550814e84fe8473ce to your computer and use it in GitHub Desktop.
Download ZIP
Raw
redshfit_delete_old_data.sql
DELETE FROM schema.table
WHERE ts < (SELECT sysdate - 90);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment