I just need an example of how this can be done. I have a table that stores a PersonID, a StatusID, and a Date field. A PersonID will be recorded several times with differing StatusIDs and Dates. I want a listing of all PersonID whose most recent record's StatusID = ??. I can not figure out how to do this.
Example SQL statement to return results needed