how to find last visited date?

Question

I have a table like 1 john 30-05-2016 2 scott 25-05-2016 3 john 05-05-2016 4 tig 28-05-2016 5 scott 22-05-2016 6 tig 30-05-2016 7 scott 29-05-2016 8 john 31-05-2016 9 tig 30-05-2016 how to find the last visited date of the each person?

Jitendra Kumar · Answer

Try below code :- Select Name Max(Date) from tbl_UserVisits Group by Name

Manas Mohapatra · Answer

Try like below: SELECT * FROM tblUserVisits WHERE Id IN ( SELECT MAX (Id) FROM tblUserVisits GROUP BY Name ) --OR SELECT * FROM tblUserVisits uv INNER JOIN ( SELECT MAX (Id) as Id FROM tblUserVisits GROUP BY Name ) temp ON uv.Id= temp .Id