用java写个算法怎样把薪水相同的人的名字打印出来,如下表
Name Salary
a 2000
b 1500
c 2000
d 3000
e 1300
f 1500
------解决方案--------------------------------------------------------
这题用排序非常好。
------解决方案--------------------------------------------------------
- SQL code
select Name from Table1 t1, t2 where t1.Salary = t2.Salaryand t1.Name <> t2.Name
------解决方案--------------------------------------------------------
改一下:
- SQL code
select distinct Name from Table1 t1, t2 where t1.Salary = t2.Salaryand t1.Name <> t2.Name