SHARE
TWEET

Untitled

a guest May 19th, 2017 42 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT id, COUNT(id) AS NumOccurrences FROM legions GROUP BY id HAVING ( COUNT(id) > 1 )
  2. SELECT itemUniqueId, COUNT(itemUniqueId) AS NumOccurrences FROM inventory GROUP BY itemUniqueId HAVING ( COUNT(itemUniqueId) > 1 )
  3. SELECT id, COUNT(id) AS NumOccurrences FROM legion_members GROUP BY id HAVING ( COUNT(id) > 1 )
  4. SELECT mailUniqueId, COUNT(mailUniqueId) AS NumOccurrences FROM mail GROUP BY mailUniqueId HAVING ( COUNT(mailUniqueId) > 1 )
  5. SELECT id, COUNT(id) AS NumOccurrences FROM players GROUP BY id HAVING ( COUNT(id) > 1 )
RAW Paste Data
Want to get better at MySQL?
Learn to code MySQL in 2017
Top