I'm trying to find set of data mentioned from table TP1. I'm trying to retrieve this record through sql query so i'm finding it very difficult. Is there any better way to find the set of data from this table?
On Jul 17, 1:13 pm, Rob Wolfe <wolfe....@gmail.com> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
