Saturday, July 12, 2008

to find duplicate rows in Oracle Db

SELECT BUY_GROUP_ID, EXPOSURE_ID, TF_CATEGORY_SET_ID, HOUSEHOLD_SIZE_ID FROM EXPSR_CHNL_HHOLD_SIZE_TEMP A WHERE rowid > (SELECT min(rowid) FROM EXPSR_CHNL_HHOLD_SIZE_TEMP B WHERE A.BUY_GROUP_ID = B.BUY_GROUP_ID AND A.EXPOSURE_ID = B.EXPOSURE_ID AND A.TF_CATEGORY_SET_ID = B.TF_CATEGORY_SET_ID AND A.HOUSEHOLD_SIZE_ID = B.HOUSEHOLD_SIZE_ID);

Sphere: Related Content

0 comments: