;(&(objectCategory=User)
    (userAccountControl:1.2.840.113556.1.4.803:=2));Name;Subtree

You can read more on this here. 

You can add an additional filter to the LDAP query using the memberOf property, negating it in the search criteria as such:

;(&(objectCategory=User)
    (!(memberOf= CN=Group,OU=Org,DC=domain,DC=xxx))
    (userAccountControl:1.2.840.113556.1.4.803:=2));Name;Subtree

Will filter those special accounts right out.

SELECT columnName, COUNT(columnName) as CountOfCol
FROM tableName
GROUP BY columnName
HAVING (COUNT(columnName ) > 1))

Where columnName  is the name of the column you need to test, and tableName is the table to test.  This will return a table showing you the data and its number of occurrences.