Question

sql 重复的数据取第一条记录的ID，如何写这样的sql

Answer 1

select id
from a
where a.num = 1
group by id
having on count(id) > 1