SQL 如下,去掉重复:
SELECT C,D FROM YOUR_TABLE A
WHERE ROWID!=(SELECT MAX(ROWID) FROM YOUR_TABLE E
WHERE A.C=E.C AND A.D=E.D);
SELECT C,D FROM YOUR_TABLE A
WHERE ROWID!=(SELECT MAX(ROWID) FROM YOUR_TABLE E
WHERE A.C=E.C AND A.D=E.D);
SELECT job,mgr FROM emp A
WHERE ROWID = (SELECT max(ROWID) FROM emp E where E.mgr=A.mgr);
不就是不重复么~~~~~~~~
select distinct name from table1