I have a table (Feature class in FGDB) with 2 columns, one is the "name" and the other is a list of year values as text "Value1".
How do I obtain the lowest 5 values for EACH name?
I am trying to do this with arcpy or even select by attributes however I am lacking SQL skills to make this happen as expected.I tried this with arcpy however it comes down to SQL for this statement. I tried MIN(date) and that is only for one value.
arcpy.SelectbyAttribute_management(r"<my path>"), "New_Selection", ' [Field1] = 'lowest5' AND GROUPBY [NAME]