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 (AT) newsland (DOT) it

On Feb 28, 8:48 am, frt... (AT) virgilio (DOT) it (Nicoletta2) wrote:
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

On Feb 28, 8:48 am, frt... (AT) virgilio (DOT) it (Nicoletta2) wrote:
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

On Feb 28, 8:48 am, frt... (AT) virgilio (DOT) it (Nicoletta2) wrote:
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

"Ed Prochak" <edprochak (AT) gmail (DOT) com> wrote

Excellent response, Ed! I hope Nicoletta uses your feedback and gets back
to you.

"Ed Prochak" <edprochak (AT) gmail (DOT) com> wrote

Excellent response, Ed! I hope Nicoletta uses your feedback and gets back
to you.

"Ed Prochak" <edprochak (AT) gmail (DOT) com> wrote

Excellent response, Ed! I hope Nicoletta uses your feedback and gets back
to you.

On Mar 3, 5:54 pm, "David Cressey" <cresse... (AT) verizon (DOT) net> wrote:
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

On Mar 3, 5:54 pm, "David Cressey" <cresse... (AT) verizon (DOT) net> wrote:
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

On Mar 3, 5:54 pm, "David Cressey" <cresse... (AT) verizon (DOT) net> wrote:
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