Viewing 2 posts - 1 through 2 (of 2 total)
Hi,
You can try below solution
delete T1
from MyTable T1, MyTable T2
where T1.dupField = T2.dupField
and T1.uniqueField > T2.uniqueField
November 25, 2011 at 5:49 am
#1412969
Write the Coreleated Query to solve the this kinds of problem.
November 12, 2007 at 11:50 pm
#750477