GROUP BY clause and contains nonaggregated column and incompatible with sql_mode=only_full_group_by

I am try to add GROUP BY and MAX aggregation function with multiple joins in PDO query but drupal core side getting sql_mode=only_full_group_by error issue with multiple fields group by.
Error:
"GROUP BY clause and contains nonaggregated column 'dbname.field_name' which is not functionally dependent on columns in GROUP BY clause. this is incompatible with sql_mode=only_full_group_by issue."