KB245815: ORA-00979 error occurs when case statement is used in Group-by while Oracle native driver does not throw the error.
![Understanding the SQL CASE Statement and its many uses - Database Management - Blogs - Quest Community Understanding the SQL CASE Statement and its many uses - Database Management - Blogs - Quest Community](https://s38063.pcdn.co/wp-content/uploads/2021/09/sql-case-statement8.png)
Understanding the SQL CASE Statement and its many uses - Database Management - Blogs - Quest Community
![Understanding the SQL CASE Statement and its many uses - Database Management - Blogs - Quest Community Understanding the SQL CASE Statement and its many uses - Database Management - Blogs - Quest Community](https://s38063.pcdn.co/wp-content/uploads/2021/09/sql-case-statement5.png)
Understanding the SQL CASE Statement and its many uses - Database Management - Blogs - Quest Community
![oracle11g - Having a case statement in where clause along with constant value in Oracle causes wrong results - Stack Overflow oracle11g - Having a case statement in where clause along with constant value in Oracle causes wrong results - Stack Overflow](https://i.stack.imgur.com/VZiFn.png)