建表语句点击详见 – 查询同名同性学生名单,并统计同名人数 SELECT st.*, COUNT(1) FROM student st GROUP BY st.s_name,st.s_sex HAVING COUNT(1)>1