adspace


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


Please Help Members By Posting Answers For Below Questions

What is the current mysql version?

1105


What is current version of mysql?

1085


Which statement is used in a select query for partial matching?

1247


How to Change a users password from unix shell.

1223