证书库出现了重复数据，我是两个重复的删掉最小的ID

delete from gk4..Resource where refIdin(select MIN(refId)from gk4..Resource where  userId in (select userIdfrom gk4..Resource where loginType=0 and showResume=1group by loginType,userId,licenceTypehaving COUNT(1)>1) group by loginType,userId,licenceType)