garsaud/duplicates.sql

Created February 20, 2019 17:27

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

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

Download ZIP

SQL: Remove duplicates except one

Raw

duplicates.sql

	delete t1 from book t1
	inner join book t2
	where t1.id > t2.id
	and t1.title = t2.title
	and t1.user_id = t2.user_id
	and t1.category_id = t2.category_id;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment