Greetings folks. I have an exported table with student ID, grade level, name, address, etc. The table contains duplicates and triplicates of student IDs, as student were in program different times of their middle and high school grades (6-12). I want to first select duplicates ids, then select max gradelevel for duplicate/triplicate set. Any suggestions?
Thanks I am a newbie.