| Duplicate Records [message #80897] |
Thu, 12 December 2002 04:08  |
M.Yousuf
Messages: 1
Registered: December 2002
|
Junior Member |
|
|
I have a lot of duplicate Records in a table. how i delete it.
please help me as soon as possible.
Regards.
M.Yousuf
|
|
|
|
| Re: Duplicate Records [message #80899 is a reply to message #80897] |
Thu, 12 December 2002 12:07  |
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
|
Senior Member |
|
|
i am sure u must have a column basing on which they were duplicated.
assuming that the column name is col and the table name is tab
delete from tab a
where rowid>(select min(rowid) from tab b where a.col=b.col)
Check, that would solve your problem...
sai
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
