Expression #1 of SELECT list is not in GROUP BY

Question

hi, thuc hien cau query nay:

SELECT l.subscriberid AS subscriberid
FROM email_list_subscribers AS l,
email_queues AS q
WHERE q.recipient = l.subscriberid
AND q.queueid = 4
AND queuetype = 'send'
AND l.listid IN (1)
GROUP BY l.emailaddress
HAVING COUNT(l.emailaddress) > 1;

no bao loi:

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'emarketing_data.l.subscriberid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

 

pro nao huong cach khac phuc

Answer 1

vi my.cnf

thêm

  sql_mode = ''

hoặc

SET sql_mode = ''