Delete repeated results from MySQL query

问题:

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

回答1:

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

回答2:

select name,totalpoints
from table
group by name
order by totalpoints desc

回答3:

select distinct name,totalpoints from table

回答4:

Very easy. use following query:

SELECT totalpoints, name
FROM table_name
GROUP BY name
ORDER BY totalpoints DESC

回答5:

Please use DISTINCT keyword in your query to avoid duplicate entries