I have a table that has two fields: username and entrydate. I am trying to figure out the query to pull the latest combination of the two or most recent combination based upon the entrydate.
So for example:
The SQL I am looking to run should pull:
Since I only want the most recent record in my pull I would only get the unique values and the most recent entry for user1.