number of row that repeated
table `tbl1`

field `id,name`

id=1   name=a

id=1   name=a

id=1   name=w

id=1   name=f

id=2   name=c

id=2   name=a



how can get number of field repeated. id=1 ,name=a  ==>2













number of row that repeated
===

table `tbl1`

field `id,name`

id=1   name=a

id=1   name=a

id=1   name=w

id=1   name=f

id=2   name=c

id=2   name=a



how can get number of field repeated. id=1 ,name=a  ==>2












