Latest Tutorials| Questions and Answers|Ask Questions?|Site Map




Have Programming Question? Ask it here!
 
 
 


sunilkumar
dulication
1 Answer(s)      a year and 7 months ago
Posted in : Hibernate


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.


Advertisement
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;



Related Tutorials/Questions & Answers:
Advertisements
Advertisements
 

 

 

DMCA.com