Hi, I have one table in that am assigning a one column ID value like 1 2 3 3 3 etc and another column like Amount, know my question is how i have to find the duplicate in the ID column and i have to add the corresponding amount of repeated Id. so please tell men the solution urgently.