Thanks for your reply.It is working fine for the input given above.However When the input is having more than 10 duplicate records,I am getting only the last digit of the count.For exaple if there are 13 records with the duplicate key,I am getting only 3.Is there any solution to get 13.
Is there anyway,so that output should have the records in the order as input that means without sorting and the last column is the sum of duplicates.please let me know.
I gave you what you asked for. You showed a 1-digit count in your output so that's what I gave you by using EDIT=(T). As Krishy pointed out you can use EDIT=(TT) to get a 2-digit count (or EDIT=(TTT) to get a 3-digit count, etc). In the future, please be more careful to ask for what you actually want.