ORA-00960: ambiguous column naming in select list

ORA-00960: ambiguous column naming in select list
Cause: A column name in the order-by list matches more than one select list  columns.
Action: Remove duplicate column naming in select list.