select list is not in group by clause and contains nonaggregated column 'safwa_tender_dev.tender.tender_regno' which is not functionally dependent on columns in group by clause; this is incompatible with sql_mode=only_full_group_by knex

Technical Problem Cluster First Answered On February 12, 2021 Popularity 10/10 Helpfulness 9/10

Contributions From The Grepper Developer Community

Code Examples

Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

TPC Matrix View Full Screen

Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Comment

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
#then reconnect in mysqlworkbench or restart mysql with: service mysql restart

Popularity 10/10 Helpfulness 9/10 Language sql

Source: Grepper

Tags: clause contains expression group-by sql this

Link to this answer
Share Copy Link

Contributed on Feb 12 2021

Friendly Hawk

1,217 Answers Avg Quality 8/10

select list is not in group by clause and contains nonaggregated column 'safwa_tender_dev.tender.tender_regno' which is not functionally dependent on columns in group by clause; this is incompatible with sql_mode=only_full_group_by knex

Contents

Code Examples

Related Problems

TPC Matrix View Full Screen

Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.