sql mode for a database code example
Example 1: full sql mode
mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
Example 2: mode in sql
SELECT TOP 1 Column_Name
FROM Table_name
GROUP BY [Column_Name]
ORDER BY COUNT(*) DESC