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
5134 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

How many columns can you create for an index?

903

How do I start mysql in ubuntu?

955

How many rows can mysql handle?

883

How would concatenate strings in mysql?

946

What is datadir?

822

How do I change a procedure in mysql?

938

what is the default port for mysql server? : Mysql dba

983

what is a cursor? : Mysql dba

937

What is the use of mysqli_fetch_assoc?

852

What is a definer?

824

How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

1024

What are the differences between char and varchar?

1040

What is the maximum connection pool size?

904

What is heap table in mysql?

911

How to create table with same structure of student table in mysql?

896