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
s1,
s2,
s3,
s4,
s5,
s6,
s7,
s8
- 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…