Skip to content

Instantly share code, notes, and snippets.

@achmadhadikurnia

achmadhadikurnia/query_to_delete_all_except_latest_x_records.sql

Last active April 4, 2023 02:41
Show Gist options
  • Save achmadhadikurnia/6f91d8773441f826cf5c6e428717b031 to your computer and use it in GitHub Desktop.
Save achmadhadikurnia/6f91d8773441f826cf5c6e428717b031 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query_to_delete_all_except_latest_x_records.sql
DELETE FROM table WHERE id NOT IN (
SELECT id
FROM (
SELECT id
FROM table
ORDER BY id DESC
LIMIT x
) temporary
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment