Oracle Error ORA-00960: ambiguous column naming in select list

Oracle Error Message

ORA-00960: ambiguous column naming in select list

Reason for the Error

A column name in the order-by list matches more than one select list columns.

Solution

Remove duplicate column naming in select list.