Hi Sabrina,
One of my table has duplicates but which is a valid record. So I could not able to set a primary key for it.
Is there any way to differentiate and identify the duplicates records?
Example:
Input:
Name
-------
Shong
Shong
Ross
Shong
Patrick
Ross
I need a output like:
s.no identifier name
----- ---------- -------
1 1 Shong
2 2 Shong
3 1 Ross
4 3 Shong
5 1 Patrick
6 2 Ross
Thanks