如果其中一行包含特定值，则返回列中具有重复值的行

I'm attempting to query against a table to determine where a value is assigned multiple times but one of assignees must equal a determined value. I'm attempting to query against a table to dete