MySQL Forums
Forum List  »  MySQL Workbench

Re: Server times out when GROUP BY has more than one group
Posted by: Peter Brawley
Date: March 02, 2021 11:13AM

> "MySQL has no way of knowing that it's meant to aggregate."
> -- I gather that I'm using a nowhere approach.

Dunno what a "nowhere approach" is. The function you wrote cannot worh in the way you are trying to use it.

> I can do my own GROUP BY by specifying a specific
> department in a WHERE clause and repeat it for the
> other 8 departments and get the desired result

In order to write a correct query, you need to start with an specific, unambiguous & complete description of the query requirement, in plain non-technical English.

Once you've done that, post it here along wioth the results of Show Create Table for all tables needed in your query. Then help will be possible.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Server times out when GROUP BY has more than one group
26
March 02, 2021 11:13AM


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.