second day transaction date of customer

sridinesh2009 · Post by **sridinesh2009** » Tue Dec 08, 2009 1:19 am

Find the second day transaction amount for a Accnt_id.

Ex: Epected records are marked in red.
Acct_Hist
Accnt_id, Trans_Dt, Seq_Num
1001 23-10-09 1
1001 24-10-09 1
1001 25-10-09 1
1002 26-10-09 1
1002 27-10-09 1
1002 27-10-09 2
1002 28-10-09 1

Output:
Accnt_id, Trans_Dt ,Seq_Num
1001 24-10-09 1
1002 27-10-09 1
1002 27-10-09 2

ray.wurlod · Post by **ray.wurlod** » Tue Dec 08, 2009 3:16 am

Welcome aboard.

If your data are sorted, then this is a straightforward application of using stage variables to compare the current row with the previous row.

However, the logic in your example does not appear to match your words.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Dec 08, 2009 3:18 am

An exactly identical query was answered couple of days ago.

chulett · Post by **chulett** » Tue Dec 08, 2009 6:54 am

As noted, your example doesn't match what you say you need, nor is there any red that I can see. Why is there a record for 24-10-09 in the output?