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....
|