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
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
Why mysql is so popular?
What are the other commands to know the structure of a table using mysql commands except explain command?
What are the 'mysql' command line arguments?
How do I fix a crashed mysql database?
How do I clear the command in mysql?
Is mysql good for big data?
What are the features of mysql?
What is the current mysql version?
How do I restore a mysql database?
What does mysqli_fetch_assoc do?
Can mysql handle billions of records?
Why we use mongodb instead of mysql?
How you can create a trigger in mysql?
How do I run mysql from command line?
What is myisamchk?