satya rajesh
New Member
- Joined
- Jan 9, 2015
- Messages
- 3
Hi
I have a requirement where the duplicate rows has to be removed from a range of columns.
Example input:
RowNo emplid firstname phonetype phonenum rownumber deptid deptname joindate rownumber
1 1001 abc home 88888 1 551 cse 10/10/2010 1
2 1001 abc home 88888 2 552 ece 10/11/2011 2
3 1002 pqr mobile 99999 3 223 civil 14/1/2013 3
Output:
RowNo emplid firstname phonetype phonenum rownumber deptid deptname joindate rownumber
1 1001 abc home 88888 1 551 cse 10/10/2010 1
2 2 552 ece 10/11/2011 2
3 1002 pqr mobile 99999 3 223 civil 14/1/2013 3
As shown in the above output the second row containing the duplicate values between the first row number and the second rownumber column have to be deleted.
The solution should span over all the row number columns that gets repeated and remove the duplicates accordingly.
I have a requirement where the duplicate rows has to be removed from a range of columns.
Example input:
RowNo emplid firstname phonetype phonenum rownumber deptid deptname joindate rownumber
1 1001 abc home 88888 1 551 cse 10/10/2010 1
2 1001 abc home 88888 2 552 ece 10/11/2011 2
3 1002 pqr mobile 99999 3 223 civil 14/1/2013 3
Output:
RowNo emplid firstname phonetype phonenum rownumber deptid deptname joindate rownumber
1 1001 abc home 88888 1 551 cse 10/10/2010 1
2 2 552 ece 10/11/2011 2
3 1002 pqr mobile 99999 3 223 civil 14/1/2013 3
As shown in the above output the second row containing the duplicate values between the first row number and the second rownumber column have to be deleted.
The solution should span over all the row number columns that gets repeated and remove the duplicates accordingly.
