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!