A
angellover
Unregistered / Unconfirmed
GUEST, unregistred user!
有兴趣还可以研究一下:<br>select distinct a.id,a.name,a.sc from table1 as a INNER JOIN table1 as b on a.name=b.name and a.sc=b.sc where a.id<b.id;