SELECT st.*,COUNT(1)
FROM student st
GROUP BY st.s_name,st.s_sex
HAVING COUNT(1)>1
-- 30、查询同名同性学生名单,并统计同名人数
最新推荐文章于 2025-05-23 19:10:48 发布
SELECT st.*,COUNT(1)
FROM student st
GROUP BY st.s_name,st.s_sex
HAVING COUNT(1)>1