How to ignore SELECT list is not in GROUP BY?
if we need select many field in mysql, at the same time,we only need group by one of these filed,in laravel or other framework,it will show Syntax error like SELECT list is not in GROUP BY clause…
solve this problem,we can use ANY_VALUE() function in mysql.
example:
SELECT name, ANY_VALUE(address), MAX(age) FROM t GROUP BY name;
solve perfectly!