在列中查找具有匹配值的记录

您可以按count>1. 但这只会返回phoneboxrecordid和具有该id的记录的#

SELECT Count(*) [Count] , phoneBoxRecordIDs FROM phoneBox Group By phoneBoxRecordIDs Having Count(*) > 1

如果你想要的行 phoneBoxRecordIDs 出现多次,则ANSI标准方法使用窗口函数:

select pb.*
from (select pb.*, count(*) over (partition by phoneBoxRecordIDs) as cnt
      from phoneBox
     ) pb
where cnt > 1
order by phoneBoxRecordIDs;

您还可以通过仅在存在匹配记录时返回记录来实现这一点:

select pb.*
from phoneBox pb
where exists (select 1
              from phoneBox pb2
              where pb2.phoneBoxRecordIDs = pb.phoneBoxRecordIDs and
                    pb2.id <> pb.id
             );