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
- 2 Answers
- 4231 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
How do I change directories in mysql?
What storage engines are used in MySQL?
What is int mysql?
What is the query to display top 20 rows?
How do I transfer data from one database to another in mysql?
How do you create a table in mysql workbench?
What is the full form of mysql?
How can you count the total number of records of any table?
all the queries used in sql
How to list or view all databases from the mysql server.
What is the limitation of mysql?
What are the column comparisons operators?
What is regex in mysql?
What is mysql in linux?
What is database in php mysql?
