I have a table with records of buildings and their inspection dates. Some buildings have been inspected multiple times. I want to return each building and the latest inspection date. Not sure if distinct and max are the ways to return each building once and the largest building date. Any help would be appreciated.
Nothing there to try...
ASKER CERTIFIED SOLUTION
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thank you very much!!!!!