Invalid use of group function MYSQL

Question

i have a problem with this query:

select distinct(id_soc)
FROM table
WHERE 
id_soc = '1234567'
AND TIMESTAMPDIFF( MONTH ,
MAX(date_ven), DATE_ADD(MAX(date_ven),INTERVAL 1 MONTH)) = 1
group by id_soc

the error is: #1111 - Invalid use of group function

but i dont know the problem, can i help me?

thanks.

Answer 1

Your results are already unique when you group then. So you do not need DISTINCT

select id_soc
FROM table
WHERE 
id_soc = '1234567'
AND TIMESTAMPDIFF( MONTH ,
MAX(date_ven), DATE_ADD(MAX(date_ven),INTERVAL 1 MONTH)) = 1
group by id_soc

Answer 2

Don't use Distinct with Group By. Remove Distinct from SELECT.