sql: 查询重复数据,并查询出,指定条件下,该重复数据出现的次数答:--查询指定条件下的重复次数--测试数据with tabname(id,name) as (select 1,'name1' union allselect 1,'name1' union allselect 1,'name1' union allselect 1,'name2' union allselect 1,'name2' union allselect 1,'name3' union allselect 2,'name1' union allselect 2,'name1' ...