On Mar 3, 5:54 pm, "David Cressey" <cresse...@[EMAIL PROTECTED]
> wrote:
> "Ed Prochak" <edproc...@[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/newssegnalagli
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.
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.
Ed
|
