Now I want to remove all duplicate value from that table with only single query
Here are a couple options:
http://www.sqlteam.com/item.asp?ItemID=3331
http://support.microsoft.com/default.aspx?scid=kb;en-us;139444
|||
Thank
Here happens like that
1) Select Distinct row from the original table and store it into tempory table
2) delete all rows from original table
3) copy the all rows from tempory table (where distinct rows inserted)
But I want to do this thing using single Delete Query
Can we do this by using only single delete query
No comments:
Post a Comment