businessinterview queastion answermysql question answer SELECT list is not in GROUP BY clause and contains nonaggregated column By findinall - April 4, 2018 0 1262 Share on Facebook Tweet on Twitter SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));