Free for PREMIUM members
SELECT yt.CrewID, yt.Lat, yt.Lon, yt.DateCreated
FROM YourTable yt
SELECT CrewID, Max(DateCreated) as DateCreatedMax
GROUP BY CrewID) ytmax ON yt.CrewID = ytmax.CrewID AND yt.DateCreated = ytmax.DateCreatedMax
ORDER BY yt.CrewID
Open in new window
SELECT x.CrewID, x.Lat, x.Lon, n.DateCreated
FROM YourTable x
SELECT MAX(y.DateCreated) DateCreated
FROM YourTable y
WHERE x.CrewID = y.CrewID
Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.
If you are experiencing a similar issue, please ask a related question
Join the community of 500,000 technology professionals and ask your questions.
Join & Ask a Question
Join our community for more solutions or to ask questions.
For immediate help use Live now!