表test
lname,b
A B
A D
A C
B A
B C
C B
D A
要得到如下记录
A D
A C
A B
B C
D B
sql语句:
SELECT * FROM test a WHERE NOT EXISTS (SELECT 1 FROM (SELECT a.* FROM test a ,test b WHERE a.lname=b.b AND a.b = b.lname AND a.lname < b.lname) c WHERE a.b=c.lname AND a.lname=c.b)