"Ed Prochak" <edprochak@[EMAIL PROTECTED]
> wrote in message
news:9ffe0610-5bb8-469a-82f7-65755e7ec682@[EMAIL PROTECTED]
> On Feb 28, 8:48 am, frt...@[EMAIL PROTECTED]
(Nicoletta2) wrote:
> > I have an oracle database with a transactions table.
> >
> > One field is the versus (Entry or Exit), another is the transaction
time.
> >
> > I have to extract who have a difference between last yesterday exit
> > transaction and first today entry transaction less then 11 hours
> >
> > Someone can help me in query building?
> >
> > The table count is about 1 milion, and daily transaction are about 3-4
> > thousands
> >
> > Nicoletta from Italy
> >
> > --
> >
> > questo articolo e` stato inviato via web dal servizio
gratuitohttp://www.newsland.it/newssegnala
gli abusi ad ab...@[EMAIL PROTECTED]
>
> A good way to write complex queries is to break down the requirements
> into parts and then put the pieces together to for the final result.
> So can you write these queries:
> 1: a query to show the last exit from yesterday?
> 2: a query to show the first entry from today?
>
> Come back with these queries and what else that you have tried and we
> can help more.
> Ed
Excellent response, Ed! I hope Nicoletta uses your feedback and gets
back
to you.
|
