hi/hello,
how to perform flag values for duplicate records..
for example if i have
empid,sal,city
100,1000,chn
101,2000,hyd
100,3000,pune in i/p stage
i should get
empid,sal,city,flag
100,1000,chn,1
101,2000,hyd,1
100,3000,pune,0
in the output.. can anyone tell me how to do this..
flags for duplicate records
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 17
- Joined: Wed Feb 06, 2008 5:09 am
-
- Participant
- Posts: 64
- Joined: Wed Sep 26, 2007 6:52 am
- Location: Syracuse ,NY