GROUP BY创建分组;HAVING过滤分组
SELECT channel,"count"(*) FROM at_account GROUP BY channel HAVING channel LIKE 'tiantuo%';
GROUP BY创建分组;HAVING过滤分组
SELECT channel,"count"(*) FROM at_account GROUP BY channel HAVING channel LIKE 'tiantuo%';
转载于:https://my.oschina.net/u/1433006/blog/1616330