假如我要查询bom_bom表中 ,cpspcode这个字段,有哪些重复了,可用用下列语句
select * from (SELECT cpspcode,count(*) as num FROM Bom_Bom group by cpspcode) as a where num>1
第一列是要重复的内容,第二列是重复了几次
假如我要查询bom_bom表中 ,cpspcode这个字段,有哪些重复了,可用用下列语句
select * from (SELECT cpspcode,count(*) as num FROM Bom_Bom group by cpspcode) as a where num>1
第一列是要重复的内容,第二列是重复了几次