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
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
what i want to check is,
> if more than one record has same value of 8 all fields...
if possible, try to give the query itself...
HAVING COUNT(*) > 1
no duplicates found!
thanks for the help...