本文共 145 字，大约阅读时间需要 1 分钟。
select * from accounts where paymode='alipay' group by name having count(name) >1;