MySQL error code
MySQL error 3597
MySQL server error 3597 is ER_WINDOW_NO_GROUP_ORDER_UNUSED, reported with SQLSTATE HY000.
ASC or DESC with GROUP BY isn't allowed with window functions; put ASC or DESC in ORDER BY
| Error | 3597 |
|---|---|
| Name | ER_WINDOW_NO_GROUP_ORDER_UNUSED |
| SQLSTATE | HY000 |
| Group | Server errors |
Source: MySQL 8.4 Error Reference