dulication

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.

View Answers

January 16, 2013 at 5:12 PM

select ,count() as n from table group by Id HAVING n>1 ; where id is the coulumn where you duplicates are there;