1.GROUP BY
SELECT username,age FROM users GROUP BY username HAVING age>23
HAVING适用于对分组设置条件
2.ORDER BY
1.GROUP BY
SELECT username,age FROM users GROUP BY username HAVING age>23
HAVING适用于对分组设置条件
2.ORDER BY
转载于:https://my.oschina.net/u/3648696/blog/1510096