select * from VirtualAppRight where ID not in (select max(t1.ID) from VirtualAppRight t1 group by t1.Name,t1.VirtualAppName); 根据2个字段重复
select * from VirtualAppRight where ID not in (select max(t1.ID) from VirtualAppRight t1 group by t1.Name,t1.VirtualAppName); 根据2个字段重复
转载于:https://www.cnblogs.com/ahghy/p/3614274.html