Link to home
Start Free TrialLog in
Avatar of mounty95
mounty95Flag for United States of America

asked on

SQL Context

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.
Avatar of jmro20
jmro20
Flag of Puerto Rico image

Try this:
Avatar of mounty95

ASKER

Nothing there to try...
ASKER CERTIFIED SOLUTION
Avatar of jmro20
jmro20
Flag of Puerto Rico image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Guy Hengel [angelIII / a3]
that would work, in this article are other options:
https://www.experts-exchange.com/A_3203.html
Thank you very much!!!!!