前几天面试遇到的,当时不太会结果吃了点亏
在上查询的写法是这样的:
select id, name, memofrom Awhere id in (select id from A group by id having count(1) >= 2)
前几天面试遇到的,当时不太会结果吃了点亏
在上查询的写法是这样的:
select id, name, memofrom Awhere id in (select id from A group by id having count(1) >= 2)