Using Group By

Hello,

I've been asked to remove all duplicate records from a database of names and address

The database is structure like this

Firstname
lastname
add1
add2
postcode
city
email

I am trying to remove the duplicates by using the group function. But I only want to group those who have the same last name and add1.

So I use this to do so...

SELECT LastName, Add1

FROM players

GROUP BY LastName, Add1;

So that works fine. But is there a way I can add the other columns (add2, firstname etc) to the results page?

If I do it this way...

SELECT Firstname, LastName, Add1, add2, postcode, city, email

FROM players

GROUP BY Firstname, LastName, Add1, add2, postcode, city, email

It wont give me an accurate result. Any suggestions how I should do this? Sorry, I'm pretty green when it comes to databases

Thanks

John