Can someone help me with finding duplicate records in a table?
can someone help me with findin duplicate record in a table ?
most probably everything right but got a doubt while testing today...
i shud have taken care of this while creating but anyhow ... i have this table called pattern
what i want to check is,
pno auto inc, primary key
- all 8 field are off the type INT and have the permission to repeat and can also have a NULL value
> if more than one record has same value of 8 all fields...
if possible, try to give the query itself...