|
Can anyone help?
Here is My Transaction File:
Client Transaction date number
X Y 20090101 55
X Y 20090201 0
The field <number> is usually 0, but if not, the user <thinks> that this will at the first transaction for a client, ie, minimum date value.
I want to prove or disprove this by extracting the 3rd line in the example, if it exists :
Client Transaction date number
X Y 20090101 55
X Y 20090201 0
X Y 20090301 2
I want any line where number<>0 and date<> min date for client, transaction.
How can I do this?
I tried something like :
With t as ( select client, transaction, min(date) from file group by etc)
Then joining to the file where number >0 and date > min(date), but my results aren't right.
Thanks.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.