Hi Gurus,
I have a scenario wherein
Cust Appntmntdt Doc Date Deposit
ABC 5/18/2007 5/25/2007 -100,000.00 INR
9/14/2007 115.00 INR
10/31/2007 3,385.00 INR
11/30/2007 0.00 INR
12/29/2007 7,581.00 INR
Now , with this i want to display first deposit of tht customer. Here, customers first deposit is on 5/25/2007 -100,000.00 INR.
The query result will be:
Cust Appntmntdt Starting Deposit
ABC 5/18/2007 -100,000.00 INR
HOw can i achieve this...??
Thanks in advance.
Vaishnavi.