check this article for solved this issue
https://afrijaldzuhri.com/mengatasi-error-group-by-di-mysql/SELECT a, b, sum(c) FROM my_table GROUP BY a; -- Error
SELECT a, b, sum(c) FROM my_table GROUP BY a, b; -- OK, all expressions there
-- CASE WHEN statement, for example:
SELECT a, CASE WHEN b=1 THEN 'Ok' ELSE 'Ko' END AS r, sum(c)
FROM my_table
GROUP BY a, CASE WHEN b=1 THEN 'Ok' ELSE 'Ko' END; -- No alias name (r)| Code Example |
|---|
| Sql :: sql latlng |
| Sql :: postgres parent and child tables |
| Sql :: postgresql newline character |
| Sql :: how to get specific salary in sql |
| Sql :: SQL Error [42501]: ERROR: permission denied for table |
| Sql :: mysql in |
| Sql :: how to check which sp is running in sql server |
| Sql :: SQL COUNT() with GROUP BY |
| Sql :: postgres delete by id |
| Sql :: delete table row in postgresql |
| Sql :: show tablespace oracle |
| Sql :: sum sqlserver |
| Sql :: sql default value if null |
| Sql :: mysql into outfile with headers |
| Sql :: sql pivot without aggregate |
| Sql :: postgresql where and |
| Sql :: psql show db |
| Sql :: power query datetime to date |
| Sql :: alter table query in mysql |
| Sql :: full outer join postgres |
| Sql :: postgresql powershell query |
| Sql :: sql limit to 5 results |
| Sql :: SQL FETCH FIRST Clause |
| Sql :: having in sql |
| Sql :: if sql |
| Sql :: como hacer un select entre fechas mysql |
| Sql :: azure sql get all users |
| Sql :: round border button tkinter |
| Sql :: datetrunc month sql |
| Sql :: do block in postgresql |