SHARE
TWEET

Untitled

a guest Oct 13th, 2019 61 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.     title, COUNT(title)
  3. FROM
  4.     cities
  5. GROUP BY
  6.     title
  7. HAVING
  8.     COUNT(title) > 1;
  9.  
  10. DELETE t1 FROM cities t1
  11. INNER JOIN cities t2
  12. WHERE
  13.     t1.id < t2.id AND
  14.     t1.title = t2.title;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top