Mehboob Ali

Mehboob Ali

  • NA
  • 25
  • 3k

i want LastSeen and Location of distinct Names

Sep 4 2019 5:37 AM
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

Answers (3)