Oracle Message ORA-00960 - ambiguous column naming in select list

ERRORambiguous column naming in select list
CAUSEA column name in the order-by list matches more than one select list columns.
ACTIONRemove duplicate column naming in select list.