Solved

SQL Context

Posted on 2011-02-11
5
244 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:mounty95
  • 2
  • 2
5 Comments
 
LVL 3

Expert Comment

by:jmro20
ID: 34874757
Try this:
0
 

Author Comment

by:mounty95
ID: 34874775
Nothing there to try...
0
 
LVL 3

Accepted Solution

by:
jmro20 earned 500 total points
ID: 34874792
The work didnt show, so i used an image SQL Code
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 34874812
that would work, in this article are other options:
http://www.experts-exchange.com/A_3203.html
0
 

Author Closing Comment

by:mounty95
ID: 34874822
Thank you very much!!!!!
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question