Thread: write a right sql statement to get this job done
View Single Post
  #2 (permalink)  
Old 03-12-10, 11:28
dav1mo dav1mo is offline
Registered User
  
Join Date: Dec 2007
Location: Richmond, VA
Posts: 782
What's going on? This same type question is popping up on all of the DB boards. The SQL is fairly simple. You want a correlated subquery, where you join the table to itself looking for the max date/time for that person.
Dave
Reply With Quote