如题所述
SELECT DISTINCT
a.字段1,
a.字段2,
FROM
table a
JOIN table b ON a.字段2 != b.字段2
WHERE
a.字段1= b.字段1
ORDER BY
a.字段2