select*from (select 姓名 from tab where 爱好 in ('游泳', '跑步') group by 姓名 having count(1) = 2) t1, tab2 t2 where t1.姓名 = t2.aaa(+)
[quote=引用 1 楼 nayi_224 的回复:] select 姓名 from tab where 爱好 in ('游泳', '跑步') having count(1) = 2;
select 姓名 from tab where 爱好 in ('游泳', '跑步') having count(1) = 2;
17,140
社区成员
55,259
社区内容
加载中
试试用AI创作助手写篇文章吧