having

\n HAVING方法也是连贯操作之一,用于配合group方法完成从分组的结果中筛选(通常是聚合条件)数据。\n\nhaving方法只有一个参数,并且只能使用字符串,例如:\n\n~~~\nDb::table('think_user')\n ->field('username,max(score)')\n ->group('user_id')\n ->having('count(test_time)>3')\n ->select(); \n~~~\n生成的SQL语句是:\n\n~~~\nSELECT username,max(score) FROM think_score GROUP BY user_id HAVING count(test_time)>3\n~~~\n