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
What are string data types?
What is the use of pdo?
What is mysql_query?
What is truncate command?
How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.
How to calculate the difference between two time values?
How do I rename a table in mysql workbench?
Can you tell how to find the number of rows in a resultset using php?
What is mysql ndb?
Explain the difference between mysql and mysql interfaces in php?
what is database white box testing? : Mysql dba
What is a string in mysql?
Where is the mysql data directory?
What is append query?
Why are function needed?