i want LastSeen and Location of distinct Names

Mehboob Ali

7y674

Here is the Table

Id Name LastSeen Location

1 john 02/04/2017 14:48 xyz
2 Sid 02/04/2017 22:48 abc

3 Sid 03/04/2017 1:48 asd

and Desired results from Table

Id    Name    LastSeen                 Location
1     john       02/04/2017 14:48    xyz
3     Sid      03/04/2017 1:48      asd

Can Some one help withe Query

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Mohanty7y ago
Accepted answer
Hey try this
SELECT * FROM tblYourTable A WHERE A.ID = (SELECT MAX(ID) FROM tblYourTable B WHERE A.NAME = B.NAME) ORDER BY ID
+1
Mehboob Ali7y ago
Thanks Amit Mohantty.
+1
Rajanikant Hawaldar7y ago
Hi Mehboob, Refer below thread and try the similar https://stackoverflow.com/questions/16550703/sql-get-the-last-date-time-record
0