I have a table with 5 columns
When rows exists with duplicate
CPT4Mod field values but different
Eff_Date values, exclude all but the most recent Eff_Date records.
I need a query which can achieve this in two scenarios.
CPT4Modis given by the user.
CPT4Modis not given by the user.
Later I need to achieve the same using LINQ.