select count(*) Number, OrgID, IdentifierTypeID, IdentifierOrder, ValidFrom
    from xdb.dbo.OrganizationIdentifier_IngestII
    where Number > 1
    group by OrgID, IdentifierTypeID, IdentifierOrder, ValidFrom

SELECT COUNT(*) AS Number, OrgID, IdentifierTypeID, IdentifierOrder, ValidFrom
    FROM xdb.dbo.OrganizationIdentifier_IngestII
    GROUP BY OrgID, IdentifierTypeID, IdentifierOrder, ValidFrom
    HAVING COUNT(*) > 1;