Hi Gurus,

I have a table with data like

SQL> select * from emp_name;

EMP_ID NAME
--------- --------------------
100 Johnny
100 Johnny
100 Johnny

I need to set the NAME (Johhny here) to null for all occurrences of emp_id except the first.

That is, I need

SQL> select * from emp_name;

EMP_ID NAME
--------- --------------------
100 Johnny
100
100



EMP_ID can occur multiple times in the table and each one would store the same name. I need to retain the emp_id because it maps to other fields also but need to eliminate the NAME in all except the first occurrence.


Thanks!