Difference between last and first transaction

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 gratuito 
http://www.newsland.it/news segnala gli abusi ad abuse@newsland.it

On Feb 28, 8:48 am, frt...@virgilio.it (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...@newsland.it

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 Prochak" <edprochak@gmail.com> wrote in message
news:9ffe0610-5bb8-469a-82f7-65755e7ec682@s12g2000prg.googlegroups.com...
> On Feb 28, 8:48 am, frt...@virgilio.it (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...@newsland.it
>
> 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.

On Mar 3, 5:54 pm, "David Cressey" <cresse...@verizon.net>
wrote:
> "Ed Prochak" <edproc...@gmail.com> wrote in message
>
> news:9ffe0610-5bb8-469a-82f7-65755e7ec682@s12g2000prg.googlegroups.com...
>
> > On Feb 28, 8:48 am, frt...@virgilio.it (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/newssegnalagli abusi ad ab...@newsland.it
>
>
>
> > 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.

I try to be helpful without doing it for others. 2 reasons:
1 If it is homework, they need to learn it. It is better to learn by
struggling thru it rather than having it done for you.
2.If it is not homework, why should I do your work for which you are
getting paid?  (unless you offer to send a check! 8^)

So Nicoletta at least try. Show us our attempts and we can help.