Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Databases General > Difference betw...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 3110 of 3210
Post > Topic >>

Difference between last and first transaction

by frtaaa@[EMAIL PROTECTED] (Nicoletta2) Feb 28, 2008 at 02:48 PM

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@[EMAIL PROTECTED]

 




 4 Posts in Topic:
Difference between last and first transaction
frtaaa@[EMAIL PROTECTED]   2008-02-28 14:48:01 
Re: Difference between last and first transaction
Ed Prochak <edprochak@  2008-03-03 05:08:09 
Re: Difference between last and first transaction
"David Cressey"  2008-03-03 22:54:58 
Re: Difference between last and first transaction
Ed Prochak <edprochak@  2008-03-04 09:24:55 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sun Jul 6 0:56:50 CDT 2008.