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
5209 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 can you handle the –secure-file-priv in mysql?

924

How can I create database in mysql?

901

What are slow queries?

891

What is myisamchk?

940

what is database black box testing? : Mysql dba

1096

How to add a new column to an existing table in mysql?

977

Is mysql good for big data?

922

What is a trigger in mysql?

1020

What are aggregate functions in mysql?

1345

Write a command with which mysql table can be repaired

923

Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.

981

What is unsigned in mysql?

912

What is mysql workbench used for?

967

How can you change the name of any existing table by using the sql statement?

980

What is the storage engine for mysql?

949