MS SQL Server 2012
So for each unique ID, I want to find the oldest date AND the Sysident of the row with oldest date.
I can get the ID and oldest date with a select ID, min(date) group by ID but I cannot figure out how to get the corresponding Sysidents
Here's one possible way to do it:
Hope this helps!