SQL Question

Last Post 31 Dec 2007 08:32 PM by nosepicker. 0 Replies.
AddThis - Bookmarking and Sharing Button
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


Acceptable Use Policy
---