Skip to content

Instantly share code, notes, and snippets.

@nahanil

nahanil/qy.sql

Created January 15, 2022 12:57
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 nahanil/ac02b551d138b9c8f5ba36ac8da18cd3 to your computer and use it in GitHub Desktop.
Save nahanil/ac02b551d138b9c8f5ba36ac8da18cd3 to your computer and use it in GitHub Desktop.
Download ZIP
sqlite: deduplicate
Raw
qy.sql
-- https://dba.stackexchange.com/a/116870
DELETE FROM sms WHERE rowid NOT IN (SELECT min(rowid) FROM sms GROUP BY address, body);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment