SQL query problem

hey I have a problem trying to get the results i need from the table.

Table1

groupno | name | date |
------------------------
1 john 1/1/2008
2 shane 2/1/2008
2 bill 1/02/2008
3 jill 9/02/2008
3 mary 25/02/2008


results i want....

groupno | name | date |
------------------------
1 john 1/1/2008
2 shane 1/02/2008
3 mary 25/02/2008


I want to retrieve all the groupno's and the name and date of the last person to login using that group no and exclude the other who have logged in previously.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories