Skip to content

Instantly share code, notes, and snippets.

@linkin-park

linkin-park/Duplicate Rows Remove

Created February 9, 2016 13:35
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 linkin-park/a14a7c897f07a9b10eaa to your computer and use it in GitHub Desktop.
Save linkin-park/a14a7c897f07a9b10eaa to your computer and use it in GitHub Desktop.
Download ZIP
Mysql
Raw
Duplicate Rows Remove
delete from cellulars1 where cid not in (select c.cid from cellulars1 c group by c.number);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment