Re: HELP! How to check missing records

Be sure. Perhaps, you would like complete test script ?

"Robert Chin" <chinman_at_optonline.net> wrote in message news:VBgB7.49382$wS2.6148114_at_news02.optonline.net...
> comrade, did you check to see if this works ?????
>
>
> "news.sovintel.ru" <valera_at_ivkplcrd.msk.u> wrote in message
> news:9r1epp$17q9$1_at_josh.sovintel.ru...
> > Hi !
> >
> > This task may be done in sql, but the computing clause is not quite
simple
> > and fast...
> >
> > For ex. you can write something like that:
> >
> > select
> > distinct
> > t0."Driver-ID",
> > t1."Trip-No"
> > from
> > Trips t0,
> > (select rownum "Trip-No" from user_tables where rownum < 10) t1
> > where
> > not exists (select NULL from Trips t2 where
t0."Driver-ID"=t2."Driver-ID"
> > and t2."Trip-No"=t1."Trip-No")
> > /
> > Regards !
> > Valery.
> >
> >
> > "Ho" <kowho_at_singnet.com.sg> wrote in message
> > news:9qt69u$bcm$1_at_clematis.singnet.com.sg...
> > > Hi ,
> > > I need to check the missing records (trip no.) of the following table:
> > >
> > > Driver-ID Vehicle-ID Trip No.
> > >
> > > ABC 1234 1
> > > 3
> > > 5
> > > 6
> > >
> > > BCD 2345 1
> > > 2
> > > 1 5
> > > ....
> > >
> > >
> > > For driver ABC mssing record are trip no 2 & 4, for driver BCD the
> > > missing records are 3 & 4.
> > >
> > > How to achieve this. Can it be done through SQL ?
> > >
> > > Many thanks for your help in advance.
> > >
> > >
> > >
> >
> >
>
>
Received on Tue Oct 23 2001 - 19:14:56 CEST