Delete repeated results from MySQL query

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

Ruben · Accepted Answer · 2011-04-29 13:03:13Z

1

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

answered Apr 29, 2011 at 13:03

Ruben

6992 gold badges16 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user731086 Over a year ago

Thanks a ton!! Too new to mysql :)

Nicola Cossu · Accepted Answer · 2011-04-29 13:01:31Z

1

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

answered Apr 29, 2011 at 13:01

Nicola Cossu

56.7k15 gold badges96 silver badges99 bronze badges

Comments

netbrain · Accepted Answer · 2011-04-29 13:03:28Z

1

select distinct name,totalpoints from table

answered Apr 29, 2011 at 13:03

netbrain

9,3046 gold badges44 silver badges69 bronze badges

Comments

Ariful Islam · Accepted Answer · 2011-04-29 13:09:59Z

1

Very easy. use following query:

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

answered Apr 29, 2011 at 13:09

Ariful Islam

7,6837 gold badges38 silver badges55 bronze badges

Comments

footy · Accepted Answer · 2011-04-29 13:16:10Z

0

Please use DISTINCT keyword in your query to avoid duplicate entries

answered Apr 29, 2011 at 13:16

footy

5,95913 gold badges54 silver badges98 bronze badges

Collectives™ on Stack Overflow

Delete repeated results from MySQL query

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related