Originally posted by hemanr
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.
How do you define the first occurance? Do you have any timestamp column in the same table? The rows are not stored in any order in Oracle tables.

Sanjay