日期:2014-05-20 浏览次数:20651 次
select Name from Table1 t1, t2 where t1.Salary = t2.Salary and t1.Name <> t2.Name ------解决方案--------------------改一下:
select distinct Name from Table1 t1, t2 where t1.Salary = t2.Salary and t1.Name <> t2.Name