RE: SQl Query Help
- From: Sanjay Mishra <smishra_97@xxxxxxxxx>
- To: Christian.Antognini@xxxxxxxxxxxx
- Date: Fri, 29 Apr 2005 08:01:01 -0700 (PDT)
Thanks you very much Christian and this is what I am looking. This has given me
the idea as how to use it in mine code
Thanks
Christian Antognini <Christian.Antognini@xxxxxxxxxxxx> wrote:
Hi Sanjay
>Now I need the output as
>Fatherid and its ChildId only and only if all of
>it Child are born in some TimeFrame. If any of the
>Child is born out of this TimeFrame then it will=20
>ignore all of those FatherId and ChildId.
To find the fathers a query like the following one should do the trick:
select fatherid
from a, b
where a.childid =3D b.childid
group by a.fatherid
having min(b.dob) >=3D to_date('01-JAN-04') and max(b.dob) <=3D =
to_date('31-DEC-04')
HTH
Chris
--
//www.freelists.org/webpage/oracle-l
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
