Home | 简体中文 | 繁体中文 | 杂文 | 打赏(Donations) | ITEYE 博客 | OSChina 博客 | Facebook | Linkedin | 知乎专栏 | Search | Email

13.3. HAVING

select * from accounts where paymode='alipay' group by name having count(name) >1;