删除MySQL查询的重复结果

Question

A MySQL query retrieves:

totalpoints --  name 
55 -- John Doe
55 -- John Doe
55 -- John Doe
55 -- John Doe
55 -- John Doe
21 -- Jean London
21 -- Jean London
13 -- Mark Derry
13 -- Mark Derry
13 -- Mark Derry
13 -- Mark Derry
4 -- Lara Croft
1 -- Ryan Mirtle
1 -- Ryan Mirtle
1 -- Ryan Mirtle

I need to show in a php page just:

totalpoints --  name 
55 -- John Doe
21 -- Jean London
13 -- Mark Derry
4 -- Lara Croft
1 -- Ryan Mirtle

How can I get rid off the repeated results? Thanks a lot

Answer 1

What about using DISTINCT? Seems pretty easy... But you actually tried to google it? ou would have found it in no time.