SQL删除重复数据/保留一条重复数据

delete from CT_FIN_ExpenseTypeConfEntry where cfexpensetypeid in --找出重复数据
(
    select etce.cfexpensetypeid from CT_FIN_ExpenseTypeConfEntry etce
    left join CT_FIN_ExpenseTypeConf etc on etce.fparentid = etc.fid
    where etc.fnumber = 14
    group by etce.cfexpensetypeid having count(etce.cfexpensetypeid) > 1
) 
and fid not in --保留重复数据中fid最小的一条
(
    select min(etce.fid) from CT_FIN_ExpenseTypeConfEntry etce
    left join CT_FIN_ExpenseTypeConf etc on etce.fparentid = etc.fid
    where etc.fnumber = 14
    group by etce.cfexpensetypeid having count(etce.cfexpensetypeid) > 1
) and fparentid = (select fid from CT_FIN_ExpenseTypeConf where fnumber = 14)