Hey guys,
A bit stuck on this one. I have a history table that contains records for each SSN. Each individual record contains a payment amount and date of payment.
I need to write a query that will return the first payment date in their history record.
Ex.
SSN Payment Date Payment Amount
11122 06/22/1957 234.44
11122 07/21/1966 123.33
11122 08/11/1980 23.33
I want my query to return the top record with the date 06/22/1957 since this is their first record. Can't figure out how to do this. Any ideas?
A bit stuck on this one. I have a history table that contains records for each SSN. Each individual record contains a payment amount and date of payment.
I need to write a query that will return the first payment date in their history record.
Ex.
SSN Payment Date Payment Amount
11122 06/22/1957 234.44
11122 07/21/1966 123.33
11122 08/11/1980 23.33
I want my query to return the top record with the date 06/22/1957 since this is their first record. Can't figure out how to do this. Any ideas?
