Oracle Error QSM-02145: GROUP BY clause is present but no aggregate functions are used

Oracle Error Message

QSM-02145: GROUP BY clause is present but no aggregate functions are used

Reason for the Error

A GROUP BY clause is used but no aggregate functions are present in the select list.

Solution

Add an aggregate function to the select list.