var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: finding duplicates
i need to run a query which will run through a list of company names and delete any duplicate entries.
i knwo there has got to be a way to dothis but i cant think of how. it is just a simple access 2002 database table.
can anyone help here?
Re: finding duplicates
to delete duplicate entries, you need to find them, save one of each, delete all the duplicate rows, and then insert the one of each back
to find them and save one of each,
select companyname into tempcompanytable
group by companyname
delete the duplicates
delete from companytable
where companyname in
insert the single rows back
insert into companytable
Are you wanting to remove duplicates from a select query ? If so, you can use the keyword distinct.
select distinct companyname from table
So if your table have the following:
Then, the output would be: