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

Code:
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...