I have a table with Title, Effective and Expiry fields.
I want to be able to group this table based on the title
Eg. Title is - Test effective 01/01/70 expiry 12/31/71
Test effective 01/01/72 expiry
Test effective 9/2/73 expiry
Test effective 1/1/2000 expiry
Digital effective 7/1/2000 expiry
Test effective 1/2/2001 expiry
Super effective 10/2/2002 expiry
Digital effective 1/2/2003 expiry
I want to write a query to retrieve records from this
Group by the Title and dates together.
For the above eg. It should retrieve me results as -