方法1: SQL> Select * FROM table_name A WHERE ROWID > ( SELECT min(rowid) FROM table_name B WHERE A.key_values = B.key_values);方法2: SQL> select * from table_name t1 where exists (select 'x' from table_name t2 where t2.key_value1 = t1.key_value1 and t2.key_value2 = t1.key_value2 and t2.rowid > t1.rowid);
SQL> Select * FROM table_name A WHERE ROWID > (
SELECT min(rowid) FROM table_name B
WHERE A.key_values = B.key_values);方法2:
SQL> select * from table_name t1
where exists (select 'x' from table_name t2
where t2.key_value1 = t1.key_value1
and t2.key_value2 = t1.key_value2
and t2.rowid > t1.rowid);
http://www.oracle.com.cn/cgi-bin/topic_show.cgi?id=4983&h=1&bpg=1&age=0
http://www.oracle.com.cn/cgi-bin/topic_show.cgi?id=4873&h=1#16842
http://www.oracle.com.cn/cgi-bin/topic_show.cgi?id=4394&h=1#14785