SELECT
某一列,
COUNT( 某一列 )
FROM
表
GROUP BY
某一列
HAVING
某一列,
COUNT( 某一列 )
FROM
表
GROUP BY
某一列
HAVING
COUNT( 某一列 ) 〉1
select t.family_id, count(t.family_id) from USER_FAMILY t group by t.family_id having count(t.family_id) >1