[thelist] SQL- grouping and dates

[Anthony Baratta]

You'll need to do a second query for each "Root". I'd do it this way:

SELECT MAX(Updated) FROM WHERE Root = 'A'
---
Anthony Baratta
President
Keyboard Jockeys