On Jul 16, 11:29 pm, David09 <mykhis...@gmail.com> wrote: > 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?
so let me see if I have this right you want the record(s) with (id1=1234 and id2=9807) or with ( id1=6746 and id2=2528) or with (all those other combinations you have listed) correct? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
