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
- 4242 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 to list or view all databases from the mysql server.
What is different between sql and mysql?
Differentiate CHAR_LENGTH and LENGTH?
How to load a csv file into a table
What port is mysql running on?
How do I select a table in mysql?
Is there a free version of mysql?
What is join in mysql? What are the different types of join?
what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL
Is Mysql query is case sensitive?
How do I flush privileges in mysql?
How is data stored in mysql?
How do I edit a database in mysql workbench?
What is limit in mysql?
How can we convert between Unix & MySQL timestamps?
