MSSQL Simple query to include all columns based upon the MAX of one. I feel dumb : I've read through a lot of other articles and at this point I think I'm just beating my head against a wall. If any of you could explain how I would replace this statement

SELECT * FROM EmployeeInformation

I want to see all columns in table EmployeeInformation with ONLY the most recent RateChangeDate.  I've tried MAX(RateChangeDate) and I'm just having no luck. An acceptable output with be as follows;

Walters, Rob	Senior Tool Designer	29.8462	2011-12-15 00:00:00.000	rob0@adventure-works.com

[MSSQL Query][1]


  [1]: https://i.stack.imgur.com/Mdz07.png