On Jul 16, 11:48 pm, David09 <mykhis...@gmail.com> wrote:
> Yes
>
> On Jul 17, 1:36 pm, Rob Wolfe <wolfe....@gmail.com> wrote:
>
>
>
> > 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?
This is probably going to sound rude but ...
I am assuming that you have written sql with a where clause before. If
that is the case, a little thought about the AND and OR operators
along with parentheses "(" and ")" and then re-reading my previous
answer should give you enough of a hint to get your answer.
If i am being too vague please feel free to explain what it is that
you are missing.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
