Re: Difference between last and first transaction

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]
 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