select * from ( SELECT ROW_NUMBER() OVER(PARTITION BY jlbh,fgs ORDER BY jlbh) AS rowNumber ,bmh AS [部门号(经销商)] , khbh AS [客户编号(经销商)] , khmc AS [宫户名称(经销商)] , fgs AS 分公司编号, fgs1 AS 分公司简称 , glzrbh AS 管理主任编号 , glzr AS 管理主任姓名 , jlbh AS 经理编号 , jlmc AS 经理名称 , bbzbh AS 本部长编号 , bbzmc AS [本部长名称(姓名)] , lsbh AS 理事编号 , lsmc AS [理事名称(姓名)] , lsh AS 理事号 , fzbh AS 副总编号 , fzmc AS 副总名称 , fzh AS 副总号 , shrq AS 经销商出生年月 , jlsrrq AS 经理出生年月 FROM dbo.t_zrxx1006 WHERE (khbh <> 'GS') and jlbh in ( select jlbh from ( SELECT count(distinct fgs) AS c , jlbh FROM dbo.t_zrxx1006 WHERE (khbh <> 'GS') group by jlbh )a where a.c > 1 ) ) tmp where tmp.rowNumber = 1 这个方法搞定 select fgs, jlbh, jlmc from t_zrxx1006 where jlbh like'%1I0044' group by fgs, jlbh, jlmc