SQL 2000> Group By Customer for Max(BillDate)
Posted on 2008-11-12
I have a single table with each record being bill information.
Example (I have excluded some columns that would not be relevant)
BILLID (int) (Primary Key)
Each customer will have several bills (one each month). I am trying to find the amount of the last bill only. I would like to list the CUST_ACCT_NO, BILLAMOUNT, BILL_DATE only where the bill date for each customer is the max bill date (their last bill only).
I know this is somewhat simple, but I am just not getting it.
Thanks in advance!