Eliminate duplicate data from table sql

Question

I have a mysql table containing with bunch of duplicate data. for example

ID           Visited URL

1             google.com
1             facebook.com
1             google.com
1             facebook.com
2             google.com
2             google.com

I need to avoid these duplicate rows and get unique rows as follows.

ID           Visited URL

1            google.com
1            facebook.com
2            google.com

How could I do that? any suggestions??

Ormoz · Accepted Answer · 2014-09-30 16:55:16Z

2

you can use either of the following

 Select ID,VisitedURL from tablename group by ID,VisitedURL

or

 SELECT DISTINCT ID,VisitedURL from tablename

answered Sep 30, 2014 at 16:55

Ormoz

3,02111 gold badges38 silver badges50 bronze badges

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

Comments

Fappie. · Accepted Answer · 2014-09-30 16:56:59Z

0

What about SELECT DISTINCT ID, Visited URL FROM YOUR TABLE..

It will only gives you non duplicated rows;

answered Sep 30, 2014 at 16:56

Fappie.

4907 silver badges18 bronze badges

Collectives™ on Stack Overflow

Eliminate duplicate data from table sql

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related