Hello world, is there any example to remove from DB dublicated records?
Thank you
Remove db dublicates
Moderator: General Moderators
Re: Remove db dublicates
what colum type is the duplicate?(integer,string,char...)??
Re: Remove db dublicates
You mean "all of the duplicated items" or "all of the duplicated items except one"?Arsench2000 wrote:Hello world, is there any example to remove from DB dublicated records?
Thank you
There are 10 types of people in this world, those who understand binary and those who don't
Re: Remove db dublicates
Do you want to delete them from the DB? or
just select distinct tuples from the table?
just select distinct tuples from the table?
Code: Select all
SELECT DISTINCT (field)
FROM table
GROUP BY field