sqlserver里查询某个字段的值（使用，分隔）里是否有重复ID问题

Question

sqlserver 
表  id (bigint) upIdList(nvarchar)

行： 1                 2，3，4 
        2                 2，3，2

Answer 1

select id AS 编号,[dishesName] AS 菜名from [dbo].[CB_Dishes]where [dishesName] in (select [dishesName] from [dbo].[CB_Dishes] group by [dishesName] having count(1) >= 2)

Answer 2

自己写个函数呗，数据量不大的话，写函数，拆开判断吧，数据量大我也想问个答案