Problem Statement: You have a table with duplicate data (say a name) in a column. Find how many times a name occurs in that column.
Simple SQL Solution:
SELECT OBJECT_NAME NAME, COUNT(OBJECT_NAME) MYCOUNT FROM GENERALDB.JAVAOBJECTS GROUP BY OBJECT_NAME HAVING COUNT(OBJECT_NAME)>0
In above SQL
Table Name = javaobjects
Database Name = generaldb
Originally posted 2009-09-21 14:42:42.