morinia
asked on
Eliminating duplicates in Sql when one field is different
I have a table (Table_A) that has 14 columns. Column named enrollment_date may change due to annual enrollments. Multiple enrollment dates is causing duplicate rows. How can I eliminate the duplicates and keep only the row with the most recent enrollment date?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.