I am new to SQL and any help is appreciated.
select person_generated_identifier as id, g.division_id as Div_id , g.programme as prog, g.expected_completion_date as Date_completed
WHERE person_generated_identifier = '228018'
the result i get from my table is
id Div_id prog Date_completed
228018 21 Contemporary Art Practice - Performance (MA) 2019-06-27 22:00:00 UTC
228018 25 MRes RCA - Arts & Humanities (MRes) 2020-09-10 22:00:00 UTC
what I do need to get is to adjust my script so that it will look at the whole table for the above (228018) user and will return the row for the lastest date_completed i.e. only returns on row with div_id 25 and completion date 2020-09-10. Basically, I need just one row per user specified by looking at the latest completion date and return the result
I hope this makes sense
Any help is aprreciated