MySQL Query Puzzle
| From: | Peter | Date: | Mon, 19 Jul 2010 04:44:30 +0000 |
| Subject: | MySQL Query Puzzle | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-306978@lists.php.net to get a copy of this message | ||
Hi All,
I have a table which contain's some duplicate rows. I just want to delete the duplicate records alone
not original records.
Assume my table as look as below
column1 column2
1
a
1
a
2
b
3
c
3
c
i want the above table need to be as below, After executing the mysql query.
column1
column2
1
a
2
b
3
c
Thanks in advance..
Regards
Peter