I'm really new to SQL.
I'm trying to create a table, using INSERT INTO, which will take just the PI data and the Pres_Start dates where the Pres_Start date is the latest, e.g.
would create a table with the following:
I've searched all over, but can't find anything that works. I would have thought this would have been fairly simple, but not to me!
500 points for a quick and working answer.