MySQL Forums
Forum List  »  Newbie

Error Code: 1111. Invalid use of group function
Posted by: Omar Qouqas
Date: November 08, 2018 04:31AM

I have been trying my best but I am now confused why this query does not work and returns an error (Error Code: 1111. Invalid use of group function). Query below:

update report_utilization ru
set avg_capacity_in = round(avg(((reports.infinera_utilisation.rx_octets*8)/900))) / reports.opsdb_circuit.circuit_absid
where year = 2017 and month = 5 and base_absid = 27957 and service_type = 'LMD';

Options: ReplyQuote


Subject
Written By
Posted
Error Code: 1111. Invalid use of group function
November 08, 2018 04:31AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.