Posted on 2010-01-08
I'm trying to modify a query where I have a policy information stored. Each time a transaction is made a new record is made. I want to return the row with the greatest transaction date.
Let's assume table name is "policy" and fields are policy-number, transaction-date, client-name, policy-effective-date, broker-name.
What does the SQL look like to return one row per policy with the latest transaction date?