选择重复KEY的最早一笔记录 select RRN(E) FROM FILEA E WHERE RR(E) > (SELECT MIN(RRN(X)) FROM FILE X WHERE X.FILELD = E.FILELD)