select * from 表名tab t where not Exists (select 1 from 表名tab where ((a=t.a and b=t.b) or (a=t.b and b=t.a)) and id>t.id)
[quote=引用 2 楼 ACMAIN_CHM 的回复:] select * from 表名tab t where not Exists (select 1 from 表名tab where ((a=t.a and b=t.b) or (a=t.b and b=t.a)) and id>t.id)
SELECT IIf([a]>[b],[a] & [b],[b] & [a]) AS 表达式1, Max(tbl.ID) AS ID之Max FROM tbl GROUP BY IIf([a]>[b],[a] & [b],[b] & [a]);
7,732
社区成员
28,799
社区内容
加载中
试试用AI创作助手写篇文章吧