Re: Server times out when GROUP BY has more than one group
> "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.
Subject
Views
Written By
Posted
595
February 16, 2021 09:57PM
305
February 16, 2021 10:32PM
352
February 18, 2021 10:38PM
357
February 18, 2021 11:52PM
357
February 19, 2021 11:58PM
Re: Server times out when GROUP BY has more than one group
349
March 02, 2021 11:13AM
Sorry, you can't reply to this topic. It has been closed.
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.