| Re: keeping distinct rows [message #52445] |
Mon, 22 July 2002 20:44 |
santosh
Messages: 85
Registered: October 2000
|
Member |
|
|
Hi Saga,
Once again i thank you for your help. I am little bit convinced by your solution. I tried myself same sort of query but actually the problem in your query and my query is same that is it deletes duplicate records based on single column and corresponding rowid values. What i want is that it should delete only those records which have all column values identical ( not single column value identical)
Regarding putting index on the table also doesnt satisfy the problem where table having many number of columns(creates problem for maintaining composite index).Hence still feel trouble for solution.
Thank you for your help
Santosh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
