MySQL Query Puzzle

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux