Hi guys,
how to identify the rowid values.i am having one table without primarykey how to remove repeated data ?
Thanks
Printable View
Hi guys,
how to identify the rowid values.i am having one table without primarykey how to remove repeated data ?
Thanks
select <column>
from <table>
group by <column>
having count(*) > 1
will give you all <column> that repeat themselves.
One other option is to create a clustered index with ignore_dup_rows option.
(check in BOL for details)
There are some other techniques to remove dupes, depending on exactly what you want to achieve. ... see other post on the same subject.
/Kenneth
------------
Nellai at 5/12/99 4:48:47 AM
Hi guys,
how to identify the rowid values.i am having one table without primarykey how to remove repeated data ?
Thanks