SQL Question

Last Post 31 Dec 2007 08:32 PM by nosepicker. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
nosepicker
New Member
New Member

--
31 Dec 2007 08:32 PM
SELECT A.*
FROM YourTable AS A
JOIN
(SELECT MemID, MAX(Date) AS Date FROM YourTable GROUP BY MemID) AS X
ON A.MemID = X.MemID
AND A.Date = X.Date
You are not authorized to post a reply.

Acceptable Use Policy