You want to delete the rows permanently or what

I want to make a query where I want to eliminate the
duplicate rows from the table.
For example :
Input : Table : NAME
Column1 Column2
India USA
USA India
UK India
India UK

The desired output that I want to eliminate the duplicates
Output
India USA
UK India
Thanks

Question Posted / supriya

2 Answers
5258 Views
Sun Life, I also Faced
E-Mail Answers

Answer Posted / supriya

You want to delete the rows permanently or what

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why mysql is so popular?

974

What are the other commands to know the structure of a table using mysql commands except explain command?

1042

What are the 'mysql' command line arguments?

1017

How do I fix a crashed mysql database?

964

How do I clear the command in mysql?

947

Is mysql good for big data?

948

What are the features of mysql?

989

What is the current mysql version?

1023

How do I restore a mysql database?

1092

What does mysqli_fetch_assoc do?

920

Can mysql handle billions of records?

1070

Why we use mongodb instead of mysql?

970

How you can create a trigger in mysql?

1007

How do I run mysql from command line?

1046

What is myisamchk?

973