On Jul 16, 11:02 pm, David09 <mykhis...@gmail.com> wrote: > I have around 10 million records in table TP1. My database version is > 9.2.0.5 > > Table TP1: > ====== > Id1 number (10); > Id2 number (10); > > I want to find the following set of data from this table > > Id1 Id2 > === === > 1234 9807 > 9807 1234 > > Id1 Id2 > === === > 4567 2502 > 2502 7945 > 7945 4567 > > Id1 Id2 > === === > 2528 4261 > 4261 5489 > 5489 6746 > 6746 2528 > > How do I retrieve these records set? Thanks in advance for your help.
What are you asking and why do you think this is a complex self join? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
