View Single Post
  #2 (permalink)  
Old 09-19-2007, 10:20 AM
Unregistered
 
Posts: n/a
Default ANY answer. Re: how do we delete redundant entries from a table ?

suppose there is a table named "test" having a column "x" having values:

x
-----
3727
3726
3728
3727
3726

Then the query would be as:
"delete from test where x in(select x from test group by x having count(x)>=2);"

Hope this would solve ur problem....
Reply With Quote