-- 30、查询同名同性学生名单,并统计同名人数
select st.*,count(1) from student st group by st.s_name,st.s_sex having count(1)>1
groupby的妙用
最新推荐文章于 2020-10-08 09:02:12 发布
-- 30、查询同名同性学生名单,并统计同名人数
select st.*,count(1) from student st group by st.s_name,st.s_sex having count(1)>1