Skip to content

Instantly share code, notes, and snippets.

@thePunderWoman

thePunderWoman/duplicates.sql

Created June 12, 2013 17:19
Show Gist options
  • Save thePunderWoman/5767296 to your computer and use it in GitHub Desktop.
Save thePunderWoman/5767296 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
duplicates.sql
WITH BULLETSQRY(partID, text, BulletCount) as (
SELECT
CB.partID, text, COUNT(*) AS BulletCount
FROM
Content C
INNER JOIN ContentBridge CB ON C.contentID = CB.contentID
WHERE cTypeID = 2 AND CB.partID = 11000
GROUP BY
CB.partID, text
HAVING COUNT(*) > 1
)
SELECT partID FROM BULLETSQRY
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment